| Subject | RE: [firebird-support] Evaluate "empty" string |
|---|---|
| Author | bogdan mordicom |
| Post date | 2017-08-17T08:08:54Z |
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
