Re: problem with returning rows with null value

> My query should return rows like:
>
> prod_id prod_srce_id
> --------------------------
> 1 AAA
> 2 BBB
> 3
> 4 DDD
>
> I tried the following:
>
> Select prod_id
> , prod_srce_id
> from products
> where prod_srce_id like nvl(p_prod_srce_id,'%')
 

Hi !
I hope this will help you ...

Select prod_id , NVL(prod_srce_id,'{NULL}')from products;  

It should return:

 prod_id prod_srce_id

 1         AAA
 2         BBB
 3         {NULL}
 4         DDD

Good Luck !

Sébastien Received on Fri Jul 19 2002 - 17:31:31 CEST