Hello all. I need to evaluate if one SP varchar parameter is "not empty". I´m using: if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then <do something>. If I send '' (empty string) as parameter content, the expression evaluates to true (I´m expecting to get a false). What am I doing wrong? Thanks!
[firebird-support] Evaluate "empty" string
Jorge Andres Brugger [email protected] [firebird-support] Wed, 16 Aug 2017 09:01:51 -0700
- [firebird-... Jorge Andres Brugger [email protected] [firebird-support]
- Re: [... Mark Rotteveel [email protected] [firebird-support]
- R... Michel LE CLEZIO [email protected] [firebird-support]
- ... 'bogdan mordicom' [email protected] [firebird-support]
- ... Svein Erling Tysvær [email protected] [firebird-support]
- ... 'bogdan mordicom' [email protected] [firebird-support]
- R... Jorge Andres Brugger [email protected] [firebird-support]
