Round or Cast?

• crazy_new

  SSCarpal Tunnel

  Points: 4804

  More actions

  September 19, 2014 at 6:41 am

  #296573

  Hey guys, I want to select a value and only return 2 places after the decimal.

  I can do it but the problem is it rounds.

  select CAST('10.454873' as decimal (10,2))

  Returns 10.45 which is what I want.

  But if I change the 3rd decimal value to 5 or higher it returns 10.46.

  How can I return the exact 2 decimal places?

• crazy_new

  SSCarpal Tunnel

  Points: 4804

  More actions

  September 19, 2014 at 7:03 am

  #1746702

  Don't worry I have the answer.

  Use Round:

  SELECT ROUND('10.456',2,1)

  This will return 10.45