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

  • Hey,

    Thanks for the reply. All I am trying to do is return a compliance percentage of @compliant/@total and I want to return a percentage with 2 decimal places if possible so 98.97 let's say

    I don't need the % in there I just want to return the percent with two decimal places or more

    Do you know a query i can use for that?