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