HELP: SQL + Null value 
Author Message
 HELP: SQL + Null value

I need to select all records with null value

"Select * from invoice where invoiceNo  =  NULL"

This does not work.  What can I do?

thanks



Mon, 16 Aug 2004 00:17:49 GMT  
 HELP: SQL + Null value
it worked, thanks


Quote:
> Vic,
> try
> Select * from invoice where invoiceNo IS NULL.

> this might be helpful
> http://accesshelp.net/survival/nullnullnull.asp

> --
> hth
> Hirantha S. Hettiarachchi MCSD,MCDBA,OCP

> Please reply only to the newsgroups.

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Mon, 16 Aug 2004 04:07:09 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. NULL Values in SQL Queries - HELP HELP

2. NULL Values in SQL Queries - HELP!

3. SQL Error writing null value field

4. dealing with NULL values in a SQL Table.

5. Populating Null value in SQL Date/Time field

6. SQL Update - Sending Null values

7. Detecting SQL NULL values

8. Pass Null Value from VB6 tp Stored Proc in SQL 6

9. Sql quary and NULL values

10. SQL query selecting null values

11. VB4 and SQL Server 6.5, Null values

12. Inserting NULL values in to int Field in SQL

 

 
Powered by phpBB® Forum Software