too complicated, less readable and i guess consuming more
Bogdan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, August 17, 2017 9:17 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Evaluate "empty" string >If (coalesce(terminal, '') <> '') then No need for coalesce since <null> is an unknown state and compared with a value it neither returns true nor false. Hence, I suspect if (trim(terminal) > '') to be equivalent to if (((CHAR_LENGTH(trim(terminal))>0) and (terminal is not null)) Set --- Ta e-pošta je bila pregledana z Avast protivirusnim programom. https://www.avast.com/antivirus