If the SET EXCAT is OFF '123456789' will be equal of an empty string e.g.
? '123456789' = ''
? '123456789' = SPACE(0)
but
? '123456789' = ' '
? '123456789' = SPACE(1...)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.