title: How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
body: <p>How do you rewrite expressions containing the standard <code>IS DISTINCT FROM</code> and <code>IS NOT DISTINCT FROM</code> operators in the SQL implementation in Microsoft SQL Server 2008R2 that does not support them?</p>