NULL Values in SQL Queries - HELP! 
Author Message
 NULL Values in SQL Queries - HELP!

you must use "is null" or "is not null"
in your case :
Select * from author where author_tel_no is not null
hope helps you


Mon, 01 Jan 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. NULL Values in SQL Queries - HELP HELP

2. SQL query selecting null values

3. Parameter Query/Null Value help

4. Paramter Query/Null Value help

5. HELP: SQL + Null value

6. Help: Recordset values and SQL queries

7. How to pass single, multiple or null parameter value(s) to multiple queries

8. Null values in Parameter queries (or Wildcards)???

9. Null values in Parameter queries (or Wildcards)???

10. Query Engine Error: Db Null Values

11. How to handle null values in VB.NET query

12. assign NULL values from query to variables

 

 
Powered by phpBB® Forum Software