Check null in case statement sql server 2008

Is there any better way to write the lines below in SQL Server ? Improve this question. Jon Seigel Tripz Tripz. Define "better". You should be able to accomplish this with the statement below. Bappy Why would it be better than Jay's answer? Show 4 more comments. Active Oldest Votes. Improve this answer. Jay Jay. Any suggestions please — user Not a problem woot, glad to have helped. Good luck with the rest of your project — freefaller. Grisha Weintraub Grisha Weintraub 7, 1 1 gold badge 22 22 silver badges 43 43 bronze badges.

Najzero Najzero 3, 15 15 silver badges 18 18 bronze badges. Getting old and confused by all the sql-derivates. Try this IsNULL should be checked. Anish V Anish V 2 2 gold badges 14 14 silver badges 31 31 bronze badges. Ankur 5, 19 19 gold badges 35 35 silver badges 62 62 bronze badges. Santosh wavare Santosh wavare 19 1 1 bronze badge.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Active Oldest Votes. Mitch Wheat Mitch Wheat k 42 42 gold badges silver badges bronze badges. Sometime you need case isnull column, 99 when 99 then "null" when 1 then Do you know why this is true?

My SQL database will not accept "case when data is null" at all. Aziz Shaikh Riya Riya 1. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back