formatting numeric value to char with special displaying value

• luissantos

  SSCertifiable

  Points: 7391

  More actions

  July 25, 2008 at 6:03 pm

  #194635

  Hello comunity

  i need to transform a numeric value to char value but with a specific format:

  ex: my numeric field value = 12200.25

  with cast('12200.25' as char) the result is 12200.250000

  i need this : 12.200,25

  in VFP i have STRTRAN() function but not in SQL

  Someone could give me an ideia

  Many thanks

  Luis Santos

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  July 25, 2008 at 8:06 pm

  #848743

  select replace(

  replace(

  replace(

  convert( varchar(16), cast(1234.20 as money), 1 )

  ,'.','!')

  ,',','.')

  ,'!',',')

  seems like a candidate for a UDF.

• luissantos

  SSCertifiable

  Points: 7391

  More actions

  July 28, 2008 at 4:06 am

  #849032

  Hello Antonio

  Thanks for your reply they work fine

  Luis Santos