Rules for SQL developers

  Click link for explanation/example.

Only use ISNULL() to check for nulls, but never to return or assign a value.  Instead, use COALESCE().