<p>How to check for null in case statement in SQL Server 2008</p>

<pre class="prettyprint"><code>CASE WHEN column IS NULL THEN 1 ELSE 0 END </code></pre>

<p>Sometime you need <code>case isnull(column, 99) when 99 then "null" when 1 then ....</code></p>

case null SQL Server 2008

CASE WHEN column IS NULL THEN 1 ELSE 0 END

197

answered Oct 07 '22 21:10

Sometime you need case isnull(column, 99) when 99 then "null" when 1 then ....

answered Oct 07 '22 22:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!