Pass Complex Parameters | Your Suggestion Please

[Jassim Rahma]

Hi,

I need your suggestion please.

I have populate_members stored procedure and I want to pass values from my .NET MAUI app:

param_nationality -> will pass blank or 2 digits country code

param_gender -> will pass M, F or blank

param_country -> will pass blank or 2 digits country code


Then in my SELECT query, I want to say:

if nationality is blank then do not add it to the query but if it's not blank the nationality = param_nationality

if gender is blank then do not add it to the query but if it's not blank the gender = param_gender

if country is blank then do not add it to the query but if it's not blank the country = param_country


Kindly advise.


Thanks,
Jassim