Home Forums SQL Server 2005 T-SQL (SS2K5) Conversion failed when converting the varchar value '12.00' to data type int. RE: Conversion failed when converting the varchar value '12.00' to data type int.

  • June 15, 2013 at 12:22 am

    #1624322

    thank you very much sir...it works well .and i have to sum both the values so i tried this but the same problem?

    SET @total = CAST(( CAST(ISNULL(@mv_mark, 0) AS INT) + CAST(ISNULL(@ob_mark, 0) AS INT)) AS VARCHAR)