A trivia SQL string function SPACE()

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?

Advertisements