-- works in MySQL, fails in MSSQL
SELECT * FROM contacts WHERE IFNULL(title,’’)=’CEO’;

-- works in MSSQL
SELECT * FROM contacts WHERE ISNULL(title,’’)=’CEO’;