When do you want to do this? When a number is inserted, or when it is
retrieved?

-----Original Message-----
From: Shawn Smith (William) [mailto:[Email Address Removed] Tuesday, February 19, 2002 10:03 AM
To: [Email Address Removed] SQL Statement help


Gurus,
I need to round a number UP to the nearest tenth...64 becomes 70, 50.5
becomes 60, etc.


Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page