Home Forums SQL Server 2005 T-SQL (SS2K5) CONVERT nvarchar to numeric RE: CONVERT nvarchar to numeric

  • April 17, 2009 at 7:22 am

    #979649

    try using a CASE statement like

    SELECT column_13

    , CASE ISNUMERIC(column_13)

    WHEN 1 THEN CONVERT(numeric(18,2),column_13)

    ELSE 0.00

    END

    FROM #temp

    Francis