truncate numbers 1

[dswitzer]

2 questions (SQL2000):
1. how can I truncate the decimals:

3205.15 --> 3205
3199.99 --> 3199
3155.00 --> 3155

2. How can I round down to the hundreds:
3205.15 --> 3200
3199.99 --> 3100
3155.00 --> 3100

If someone can point me in the right direction, it would help.

Thanks.

Dave

 

[SQLDenis]

convert to int and floor

select convert(int,3205.15),floor(3205.15/100) * 100

select convert(int,3199.99),floor(3199.99/100) * 100

there is also ceiling if you need to round up




Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[dswitzer]

Very cool - very cool....