SPACE

STR, SPACE, LTRIM and RTRIM functions

String functions in MS SQL SERVER