On 16-8-2017 17:53, Jorge Andres Brugger [email protected] [firebird-support] wrote: > 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?
An empty string is not null, so even though (CHAR_LENGTH(trim(terminal))>0) might be false, (terminal is not null) is true, so the IF evaluates to true and is executed. Maybe you meant AND instead of OR? -- Mark Rotteveel
