Case select null

You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. After working in the motor trade for over 11 years Adrian decided to give it all up to persue a dream of working in I. Create a website or blog at WordPress.

Share this: Twitter Facebook. Like this: Like Loading Thanks for Sharing.. Good Catch.! Thanks Deepak Like Like. Here's what the syntax looks like:. In a simple CASE expression, the name of the column or expression to be evaluated is absolutely necessary. It goes after the CASE keyword. The set value goes after the WHEN. If the evaluated value is the same the as the set value, the result defined in THEN is returned. Remember, ELSE is optional. The following example queries are based on data from the animal table, as shown below:.

This example selects data from the animal table and displays the name of the animal's current zoo. You can also put an expression after the CASE keyword. Imagine that, besides animals' weights in kilograms, you would also like to display the total weight of mammals by species — but only if these values are special.

In this case, three characteristic numbers must be determined. They will be displayed as strings. If the total weight is not one of these three numbers, then other will be shown.

Here's the same code without an ELSE :. The CASE expression can have an alias, or a name for the resulting new column. The above query, now with an alias, looks like this:. This query selects data from the table and displays the continent where the animal comes from. The searched CASE expression is the most commonly-used format. But instead of comparing a column or expression against a defined set of values, a searched expression can compare multiple WHEN conditions and determine a result.

This makes a searched CASE the better choice for more complicated logic. Once again, the expression begins with the CASE keyword, but there is no column name or expression following.

But after the WHEN keyword, we enter one or more conditions rather than set values. These conditions will compare a retrieved value and return the first one it meets as TRUE. I didn't know that. Haven't thought that there are so much possibilities to do that. There are plenty of solutions but none covers why the original statement doesn't work. NeatNit 1 1 gold badge 2 2 silver badges 12 12 bronze badges. Ian Jacobs Ian Jacobs 5, 1 1 gold badge 22 22 silver badges 37 37 bronze badges.

Yeah realized it after I posted. Figured I'd leave it since it solved the part he was having trouble with. The problem is that null is not considered equal to itself, hence the clause never matches. Something unknown, is most likely not the same as something else that is unkown. Found a solution to this. Paul Roub Kenyadigit Kenyadigit 31 1 1 bronze badge. Frederic 3, 1 1 gold badge 20 20 silver badges 36 36 bronze badges. Linda Linda 11 1 1 bronze badge. Jason caught an error, so this works Can anyone confirm the other platform versions?

Chef Slagle Chef Slagle 3 3 silver badges 7 7 bronze badges. I hope this is a helpful alternative. Are you sure that works? Molem Molem 69 1 1 silver badge 3 3 bronze badges. Pang 8, gold badges 82 82 silver badges bronze badges. I tried casting to a string and testing for a zero-length string and it worked. Joshua Walker Joshua Walker 1.