That's right! I was focusing in the wrong place! So stupid me! Thanks a lot (also to Michel).
2017-08-16 13:20 GMT-03:00 Mark Rotteveel [email protected] [firebird-support] <[email protected]>: > 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 > > > ------------------------------------ > Posted by: Mark Rotteveel <[email protected]> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at http://www.ibphoenix.com/ > resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
