I want a Column after fix space

It's not part of SQL Server to Format/Display the output, it's always the frontend. In SSMS you could change the font for the grid, or you change the result output from "Grid" to text (right click in query Editor => Result to)

; WITH cte AS 
   (SELECT 1 AS ID, 'Hello World' AS Comment
    UNION ALL
    SELECT 1000 AS ID, 'Second Line' AS Comment)
SELECT CONVERT(char(10), ID) + Comment
FROM cte;

---

Olaf Helper

[ Blog] [ Xing] [ MVP]