Sql select statement if null

This runs but doesn't return a value for DATE, it just gives everything a null. Xin Xin Mahesh Sambu Mahesh Sambu 2 2 silver badges 13 13 bronze badges. Abdullah Zaid Abdullah Zaid 1 1 silver badge 9 9 bronze badges. Kees de Wit Kees de Wit 1, 14 14 silver badges 26 26 bronze badges. Slight variation on Mahesh solution for mssql: case when isnull B.

Amirhossein 2 2 gold badges 10 10 silver badges 31 31 bronze badges. Your welcome, please read help center and get tour for give best feedback. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field. Then, the field will be saved with a NULL value. A field with a NULL value is one that has been left blank during record creation!

Select all records from the Customers where the PostalCode column is empty. Viewed 62k times. I really can't think of a case for this, unless you use it in a subquery and join it.

You'll get better results than with these contrived examples. Also keep in mind a query never returns NULL. A column does. Show 10 more comments. Active Oldest Votes. McDermaid You should generally use EXISTS rather than forcing the server to perform a complete count if all that you care about are 0 and at least 1.

Neither of those blocks of code are correct. The first one won't even run. You'll get a syntax error. Why accept it? Umang Patwa Umang Patwa 2, 3 3 gold badges 25 25 silver badges 39 39 bronze badges. GWed GWed Wrap your column in this code.

Bobby Bobby 2, 3 3 gold badges 17 17 silver badges 35 35 bronze badges. Bad Wolf Bad Wolf 7, 4 4 gold badges 32 32 silver badges 43 43 bronze badges. Good Luck! Krishna Chavali Krishna Chavali 11 2 2 bronze badges. Chameleon Chameleon 2 2 silver badges 8 8 bronze badges. Donald Duck 7, 19 19 gold badges 67 67 silver badges 87 87 bronze badges. Chandan Kumar Chandan Kumar 1 1 1 bronze badge.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.