Null Values

This topic is locked

Null Values	8/1/2006 10:30:11 AM
PHPRunner General questions
P pdherring author Hi, Thanks everyone for your help with my previous question, i need to search for a record with the value null the code i am using is as follows $strSQLExists = "select * from dbo.WEBUsers where Username='".$_SESSION[UserID]."' and CustomerID='125'"; and i want to change the last bit to search for values that sql says is null got any ideas thanks


P	pdherring author 8/1/2006
	ok sorted it, for anyone who searches this forum for this answer it is (CustomerLocationID IS NULL)"; Thanks anyway