I have a query that is not capturing records with 'NULL' values...it captures records that has no value in the field but if the SQL table has the 'NULL' value in the field, it doesn't appear in my query. For example:
ID myID Name
1 NULL Jack
3 NULL Homer
4 IN578 Jill
5 89787 Harriett
So in my query (shown below) I want all records that doesn't have the myID that starts with IN. So in essence, I should get all records except for #4. Instead, I get #2 and #5.
Also, the funny thing is...if I don't have the NOT LIKE line in my query,, it then gives me all records.
<cfquery datasource="myDatasource" name="myQuery">
WHERE myID NOT LIKE 'IN%'