Have 2 queries and pick the one that you need. If it is null then use the
query that does not specify the d_column otherwise use the other.
Jim
"Kavous Niamir" <KNiamir_at_home.com> wrote in message
news:9SsQ7.31288$KT.7701303_at_news4.rdc1.on.home.com...
> You will have to excuse me if this sounds a bit elementary, but I'm new to
> this stuff and have to find out ASAP. I have a VB application that passes
> several parameters to a PL/SQL package. These are used in a WHERE clauses
of
> a SQL query. For example :
>
> Select a_column
> from a_table
> where b_column = ai_str1
> and c.column = ai_str2
> and d.column = ai_str3 -- the line I'm having problem with
>
> Now my problem is that a user can either send a string for ai_str3 or a
null
> value. How can I structure the query such that if the user sends a null
> value, the third condition would be simply ignored.. I have been thinking
> along the lines of having :
>
> d_column = nvl(ai_str3, d_column)
>
> Would that work or what do you think I should do?
>
> Regards, Kavous
>
>
>
>
Received on Sat Dec 08 2001 - 12:55:11 CST
