Display as Percentage - SQL Server

Databases
1

Hi,

My code below now gives a result but with too many decimal places…Here’s the output:

7941250.000000%

Is this the correct way to display as Percentage? And how do I reduce the number of 0s after the decimal?

Thanks.

DECLARE @StartingNum int
DECLARE @NumDifference numeric (38,6)

Declare @ResultsData as table
(
MyPoints varchar(80) null
)


insert into @ResultsData
(
CAST(((cast(NumDifference as numeric(38,2))/
cast(@StartingNum as numeric(5,2)))*100) AS VARCHAR(56) )+'%' AS MyPoints
)
2

best practice is to do formatting in the front end application

the query should return plain numbers, not formatted character strings

even calculations such as percentages should really be done in the front end