How to do a Select/Where x=NULL
-
I have a column that is a bit. I am looking to Select a row where this column has a null value. I have tried SELECT * From Table Where x = NULL...that doesn't work. When I look at the table through the manager, I see as the value. How do I program this? Thank You,
Jude
-
I have a column that is a bit. I am looking to Select a row where this column has a null value. I have tried SELECT * From Table Where x = NULL...that doesn't work. When I look at the table through the manager, I see as the value. How do I program this? Thank You,
Jude
TheJudeDude wrote:
I have tried SELECT * From Table Where x = NULL...that doesn't work.
SELECT * FROM Table WHERE x IS NULL
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog
-
TheJudeDude wrote:
I have tried SELECT * From Table Where x = NULL...that doesn't work.
SELECT * FROM Table WHERE x IS NULL
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog
Thank you very much
Jude
-
I have a column that is a bit. I am looking to Select a row where this column has a null value. I have tried SELECT * From Table Where x = NULL...that doesn't work. When I look at the table through the manager, I see as the value. How do I program this? Thank You,
Jude
Hi, Select * from TABLE Where X Is Null Pandian S