How can I format a zero?

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  September 25, 2001 at 2:41 am

  #77901

  Hi,

  I'm trying to return 0.00 from a procedure which uses decimals when the value is zero. However, the following code returns .00 - does anyone know a good way of doing this?

  declare @mydec as decimal (10,2)

  set @mydec = 0

  select @mydec

  Thanks in advance

  

  Paul Ibison PhD, MCSD

  email: Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  September 25, 2001 at 5:08 am

  #418444

  Reply to my own question - just in case someone else had a similar issue.

  Solution is use select cast(@mydec as varchar(12)) as MyField, and 0.00 mysteriously appears.

  Paul Ibison PhD, MCSD

  email: Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  September 25, 2001 at 10:09 am

  #418460

  Thanks for posting your solution Paul!

  cast is real handy for moving one datatype to another.

  Wes