Home Forums SQL Server 7,2000 SQL Server CE Split integer valuefrom decimal valye RE: Split integer valuefrom decimal valye

  • 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.','')