Q:

How to test for NULL in SQL query

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.

A:

Use IS NULL not '= NULL'
select User_name, User_Second_Choice 
from tbl_User where User_Assigned_Project IS NULL

