Converting a varchar to real??

• Fredy Klammsteiner

  SSC Veteran

  Points: 278

  More actions

  May 14, 2004 at 1:19 pm

  #161333

  Hi,

  in an SQL statement, I should convert a varchar (e.g. '23.467') to real.

  But neither the statement 'CAST(myVarchar as real)' nor CONVERT(real, myVarchar) works.

  Does anybody has an idea, how I can convert a varchar to a real?

  thanks and regards

   

  Fredy

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 14, 2004 at 1:56 pm

  #506540

  This works...

  declare @ch varchar(10)

  set @ch = '23.467'

  select convert(real, @ch)

   

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• SteveB-74825

  Hall of Fame

  Points: 3290

  More actions

  May 17, 2004 at 6:31 am

  #506634

  as does:

  declare @ch varchar(10)

  set @ch = '23.467'

  select cast(@ch as real)

  cheers

  dbgeezer