| Subject | AW: [firebird-support] coalesce |
|---|---|
| Author | checkmail |
| Post date | 2015-03-26T06:58:23Z |
Okay,
Thanks @ll! It was in fact a char instead a varchar item.
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 25. März 2015 22:11
An: firebird-support@yahoogroups.com
Betreff: 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.
Sean