too complicated, less readable and i guess consuming more
Bogdan From: [email protected] [mailto:[email protected]] Sent: Thursday, August 17, 2017 9:17 AM To: [email protected] 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
