Home Forums SQL Server 7,2000 T-SQL Conversion failed when converting the varchar value '12.80' to data type int. RE: Conversion failed when converting the varchar value '12.80' to data type int.

  • December 16, 2012 at 11:41 am

    #1568963

    Lowell, thank you! Your post fixed my problem converting Decimal stored as Varchar into an INT (still working in 2005 & 2008)

    select CONVERT(int,CONVERT(decimal(19,2),'12.80'))