Home Forums SQL Server 7,2000 SQL Server CE Split integer valuefrom decimal valye RE: Split integer valuefrom decimal valye
PhilPacha
Hall of Fame
Points: 3645
More actions
July 8, 2008 at 2:21 pm
#839768
or, use
ROUND(YourValue, 1)
(revised) I'm sorry... I meant ROUND(YourValue, 0, 1)
I apologize for my lack of proof-reading.
The non-zero 2nd parameter truncates the value, without changing the datatype.