How to convert a string to a numeric

• aldero

  SSC Rookie

  Points: 48

  More actions

  October 2, 2003 at 2:50 am

  #81218

  Hi all,

  Can someone help me with the syntax of converting a string to a numeric.

  Thanks a lot in advance

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 2, 2003 at 3:25 am

  #476704

  Have a look at CAST and CONVERT eg

  declare @variable varchar(10)

  set @variable = '123'

  select cast(@variable as int)

  Jeremy