List:General Discussion« Previous MessageNext Message »
From:Graham Anderson Date:March 23 2005 6:13pm
Subject:Newbie: Searching for empty fields
View as plain text  
how do you search for an empty field ?
I want to filter out records where the ipAddress field is empty

SELECT * FROM 'userLog'  WHERE 'ipAddress' IS  [empty] ?

many thanks

Newbie: Searching for empty fieldsGraham Anderson23 Mar
RE: Newbie: Searching for empty fieldsTom Crimmins23 Mar