String Formatting SPACE Function

Easy enough one but easily forgotten all the same.

Use Northwind

SELECT 'A' + SPACE(10) + 'B' AS 'formatted'

References

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_7oqb.asp