Dear all,
How to use SQL statement to search all records that a specific field is
NULL?
SELECT * FORM db WHERE field1 = 'NULL' ?
by Winno » Sun, 15 Apr 2001 19:22:28
How to use SQL statement to search all records that a specific field is
NULL?
SELECT * FORM db WHERE field1 = 'NULL' ?
by Fred Chatea » Sun, 15 Apr 2001 19:30:13
A null has no value so there can be no equality with it. In other words,Quote:> How to use SQL statement to search all records that a specific field is
> NULL?
> SELECT * FORM db WHERE field1 = 'NULL' ?
SELECT * FROM db WHERE field1 Is Null
--
Regards,
Fred Chateau
http://members.home.net/fchateau/
by Fred Chatea » Sun, 15 Apr 2001 19:33:44
Also . . .Quote:> A null has no value so there can be no equality with it. In other words,
> nothing is equal to a null.
> SELECT * FROM db WHERE field1 Is Null
SELECT * FROM db WHERE field1 Is Not Null
--
Regards,
Fred Chateau
http://members.home.net/fchateau/
Hi all,
I have the following table structure in SQL 6.5 with SP5a
created by dbo. I am able to do insert into Employee
(Name) values ('Lim') successfully without any error
despite the fact that Allow Nulls is set to no and default
value is user_name(null). Please advise. Thanks.
Employee Table
ColumnName Data TypeLength AllowNulls DefaultValue
Name Char 15
Addwho Char 18 user_name(null)
Regards
Derek
2. XML to SQL encoding hassles.
3. Concat null yields null always returns null in 70 mode
5. NULL versus IN (NULL) versus IS NULL
6. Delete with Joins is it possible ?
12. Search ALL Fields for Nulls