How to test for NULL in SQL query

Question

string query = 
  "select  User_name, User_Second_Choice 
   from tbl_User where User_Assigned_Project ='"+NULL+"'";

i try to select the rows to update so how can i change User_Assigned_Project = '"+NULL+"'";

Thank you.

Black Frog · Accepted Answer · 2013-10-25 02:05:48Z

6

Use IS NULL not '= NULL'

select User_name, User_Second_Choice 
from tbl_User where User_Assigned_Project IS NULL

Black Frog

11.7k1 gold badge37 silver badges67 bronze badges

answered Oct 25, 2013 at 1:42

David Ewen

3,7321 gold badge22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1