Home Forums SQL Server 2012 SQL 2012 - General How to show a percentage with out the decimal RE: How to show a percentage with out the decimal

  • April 21, 2018 at 12:23 am

    #1987781

    This can be simplified with the concat function.
    😎

    USE TEEST;
    GO
    SET NOCOUNT ON;

    DECLARE @PERC DECIMAL(6,4) = 1.25;

    SELECT CONCAT(CONVERT(INT,@PERC * 100,0),'%');