This is also possible
If (coalesce(terminal, '') <> '') then
Regards
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, August 16, 2017 6:39 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Evaluate
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 m...@lawinegevaar.nl
[firebird-support] :
> On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com
>
May be this :
if (terminal<>'') and ( not (terminal is null)) thendo something
With best regardsMichel
Le Mercredi 16 août 2017 18h20, "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" a écrit :
On 16-8-2017 17:53, Jorge Andres Brugger
On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com
[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 something>.
> If I send '' (empty string) as
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 .
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 a lot Set. Yes, I guess I was not able to explain my requirements
clearly.
I think because the underlying is a view, vwPriceListHistory, the query you
suggested is taking very long to run. I will try your suggestion where there
is a table rather than derived data
Kind regards
Thanks Mark. I went back to the cID as you suggested. I added a 0 padded
iItemID before the date and also padded the rest of the cID with 0 just like
you wanted (though expanded) and your query works lightening fast. I will be
able to make practical use of it I am sure.
Thanks again for