IS NULL and IS MISSING are predicates that test for a missing value. IS NULL and IS MISSING are used in the WHERE, ON, and HAVING expressions. Each predicate resolves to true if the sql-expression's ...
just some info for anyone else who's not a sql guru:<BR><BR>i did the following selection on a table:<BR><BR>SELECT * FROM Table WHERE myField <> 'active'<BR><BR>the values in that colum are a mix of ...