Format of number

• TSQL Tryer

  SSCrazy Eights

  Points: 8869

  More actions

  August 12, 2014 at 4:11 am

  #294362

  Hi,

  When I run the following part of code - Which works out a weekly rent from a monthly one

  WHEN Loc.[rent-group] = 'F' THEN COALESCE(ARENT.[NET-AMT]*12/52,0) /*To work out weekly rent on monthly run*/

  I'm getting the result coming back as "114.230769" as an example.

  How do I get it to come back as - "114.23"?

  Thanks

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  August 12, 2014 at 5:06 am

  #1737162

  WHEN Loc.[rent-group] = 'F' THEN COALESCE(CAST(ARENT.[NET-AMT]*12/52 AS DECIMAL(10, 2)),0) /*To work out weekly rent on monthly run*/

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]

• TSQL Tryer

  SSCrazy Eights

  Points: 8869

  More actions

  August 12, 2014 at 6:18 am

  #1737178

  Thank you very much. Just what I was after.