> one short question, why is the Result of
> coalesce(:variableVarchar(10),'NULL') not ,NULL' but rather 'NULL      ' with
> blanks from varchar(10) length?

What tool/application are you using to evaluate the result?

As Dmitry and Mark have already pointed out, the result should be a VarChar(10) (i.e. without any trailing spaces)

It may be the tool/application handling the result which is adding the extra blanks.


Sean