That should do it

;

WITH

CTE AS

(

SELECT CAST(ROUND(VAL,0,0) AS VARCHAR(10)) AS VAL

FROM 'YOURTABLE'

)

SELECT SUBSTRING(VAL,1,2) + '%' AS NDM$

FROM CTE