Convert string to integer

[impulse24]

Hello,

I have a table which has a numeric value stored as a string. I want to do a > query, but since the value is a string this isn't working. In VB i can do a Cint. What is the function in SQL that does this?

 

[fluteplr]

depends on what server you are using in MS SQL server it would be either cast or convert.

 

[tlbroadbent]

CAST is an ANSI-92 SQL standard.

Select CAST(stringcol As int) As intcol From table

OR

Select CAST(stringcol As decimal(8,2)) As deccol From table


Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous