Equivalent of the "VAL" function

[cyork]

Hi,

I have a column with numbers in it but the data type is text. I would like to take the numerial value of these and update them into another (numeric) column. In Access I would use the VAL function...what can I use in SQL Server?

Thank you,

Chris

 

[fluteplr]

look at cast and/or convert

 

[Guest_imported]

Hello!

Try this:

declare @str varchar(15)

set @str='45'

SELECT CONVERT(integer, @str)

 

[Guest_imported]

Hello!

Try this:

declare @str varchar(15)

set @str='45'

SELECT CONVERT(integer, @str)

Best Regards,

PEDRO VIEIRA - PORTUGAL