Home Forums SQL Server 2008 T-SQL (SS2K8) Function to replace string 'NULL' with null value RE: Function to replace string 'NULL' with null value

  • July 3, 2013 at 3:04 am

    #1629421

    Thank you

    I actually thought of something else, that I could use NULLIF function then got

    CAST(NULLIF([Gross Amount],'NULL') AS DECIMAL(18,2)) [Gross Amount]