Re: SQL ignore part of WHERE if parameter is null

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

--
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