problem with returning rows with null value

Hello,

I have a problem with returning rows with a null value using a parameter. I think it should be easy, but I am not able to create a correct query.

My query should return rows like:

prod_id prod_srce_id

1         AAA
2         BBB
3         
4         DDD

      , prod_srce_id
from products
where prod_srce_id like nvl(p_prod_srce_id,'%')

However, in this case the query doesn't return the row with prod_id 3. Do I have to use the decode function? If so, how would it look like?

Thanks in advance,

Xander Received on Fri Jul 19 2002 - 11:56:25 CEST