http://www.sommarskog.se/dynamic_sql.html

Erland Sommarskog made a comprehensive summary of dynamic SQL issues. Very thorough and very useful for quick reference. He's also illustrated differences between versions of SQL where relevant.

He also shows when to use/avoid isNull and coalesce -- an important consideration if the search field allows nulls or not.