Hi all,

I'm with another doubt here!

Can't I use the NULL for parameters comparison like bellow?

SELECT C.NOME FROM CUSTOMERS AS C WHERE :pCode IS NULL OR C.CODIGO =
:pCode;

In this situation I want to select all customers if the pCode parameter
is NULL or just one customer if the :pCode parameter was informed.

Thanks again,

Fabrício F. Kammer
Conchal/SP Brazil


[Non-text portions of this message have been removed]