Home Forums SQL Server 7,2000 SQL Server CE Split integer valuefrom decimal valye RE: Split integer valuefrom decimal valye
krs
SSC Journeyman
Points: 91
More actions
August 9, 2011 at 11:31 am
#1366100
vchandm23:
What about using modulus (%)? Like some flavor of the following:
select replace(1234.4321 % 1 ,'0.','')