Male, Female and The Other One (NULL)

Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on the the issues with dealing with NULL’s specifically with the fact that a logical expression can return TRUE, FALSE or UNKNOWN.

http://www.sqlservercentral.com/columnists/pward/malefemaleandtheotheronenull.asp