Rounding UP values

• kiril.lazarov.77

  Hall of Fame

  Points: 3742

  More actions

  November 28, 2014 at 2:19 pm

  #298995

  Hi,

  I need to round UP values but they should never be rounded down, below is my expected output in RoundVal column. Thanks!

  SELECT 89 AS Val, 100 AS RoundVal UNION ALL

  SELECT 329, 1000 UNION ALL

  SELECT 6329, 10000 UNION ALL

  SELECT 43299, 100000 UNION ALL

  SELECT 155329, 1000000

• stook

  SSC Enthusiast

  Points: 126

  More actions

  November 28, 2014 at 2:51 pm

  #1761485

  declare @t table (x int)

  insert into @t values (89),(329),(6329),(43299),(155329)

  select x, power(10,len(x)) from @t