Re: SQL ignore part of WHERE if parameter is null

Hi Mónica, test this:

select * from ncnotl
where case when ncnlnorn 《》 ' ' then ncnlnorn else '1' end = case when
ncnlnorn 《》 ' ' then :wnorn else '1' end
and case when ncnldtpco 《》' ' then ncnldtpco else '1' end = case when
ncnldtpco 《》 ' ' then :wndtpco else '1' end


Orlando Misas
Zettabyte ltda


El lun., 9 de marzo de 2020 20:34, Michael Quigley <
MichaelQuigley@xxxxxxxxxx> escribió:

Actually, Mike's idea works to do exactly what you want--although it's
somewhat wordy. You just surround each condition in parentheses and do an
or
with the value compared to the literal ' '.

Michael Quigley
Computer Services
The Way international
www.TheWay.org

-----Original Message-----

message: 7
date: Sun, 8 Mar 2020 04:43:21 +0000
from: M?nica Anast?cio <monicaanastacio@xxxxxxxxx>
subject: Re: SQL ignore part of WHERE if parameter is null

Imagine u have 5 ou more fiels of selection I want to have just 1 select

with

all the fields and if when a field dont have information, ignore



Mike Jones <mike.jones.sysdev@xxxxxxxxx> escreveu em s?b, 7/03/2020 ?s
17:54 :

Hi Monica,

I think you're looking for something like this:

select * from ncnotl
where ( :wnnorn = ' ' or ncnlnorn = :wnnorn ) and ncnldtpco =
:wndtpco

Mike

On Sat, Mar 7, 2020 at 12:50 AM M?nica Anast?cio <
monicaanastacio@xxxxxxxxx>
wrote:

select * from ncnotl
where ncnlnorn = :wnnorn and ncnldtpco = :wndtpco

anyone now if its possible to ignore this - ncnlnorn = :wnnorn -
when

the

field has no information and pass to the other condition.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com