Hello All

I have a problem with an SQL query. The query is quite simple cause i need
to get all the rows of a table which have a field set to null.

For exaple consider this table:

CUSTOMERS
----------------------------------------
NAME | SECOND_NAME | LAST_NAME | ADDRESS
----------------------------------------

I need to geet all the customers which have SECOND_NAME set to NULL.

I tried something like this:

SELECT * FROM CUSTOMERS
WHERE SECOND_NAME=NULL;

But the DB2 gives me an error: "NULL is invalind in the context it is used"

How can I select all the rows which have second name null?

Thanks

--
Nel tempo dell'inganno universale
dire la verità è un atto rivoluzionario
(George Orwell)


ICQ:61810110
YAHOO!:Kiavick

try:

WHERE SECOND_NAME is NULL

Kiavik wrote:

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands