Subject AW: [firebird-support] coalesce
Author checkmail



Thanks @ll! It was in fact a char instead a varchar item.


Von: []
Gesendet: Mittwoch, 25. März 2015 22:11
Betreff: RE: [firebird-support] coalesce



> 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.