|Subject||RE: [firebird-support] coalesce|
> one short question, why is the Result ofWhat tool/application are you using to evaluate the result?
> coalesce(:variableVarchar(10),'NULL') not ,NULL' but rather 'NULL ' with
> blanks from varchar(10) length?
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.