Not a really an important function, but SPACE returns a set number of spaces. For example
SELECT "HELLO" + SPACE(10) + "WORLD"
----------------------------------------------
HELLO WORLD
I guess you can just use ” ” instead of SPACE(10), is there any specific good reason to use this function?
A trivia SQL string function SPACE()
26 03 2008Comments : 1 Comment »
Tags: space, sql function, T-SQL
Categories : T-SQL, Technical
