How to bring all records

[AIMAM]

hello,

i have the following line in a query:

AND (mmt.ATTRIBUTE1)= NVL(:P _Subject,mmt.ATTRIBUTE1)

It gives me only the not null "mmt.ATTRIBUTE1" records when the parameter is not entered.

How can i modify this in order to bring all the records even where the column mmt.ATTRIBUTE1 is NULL

Thank you..

[crom]

Hello,

try this:

and nvl(mmt.attribute,'!!') =
nvl(:p_subject,nvl(mmt.attribute,'!!'))

I hope it helps !