Ars Technica

SQL: behavior of "WHERE Fieldname <> 'foo'" with null values, best solution?

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 ...