.NET Answers

I’ve had to do this a couple of times and I just realized I haven’t written about it anywhere.

If you need to SELECT a field from a row that returns different content based on the content of the field, you’d think, based on previous programming experience, that your code would look something like this.

SELECT IIF(field=2,"content true","content false")
   FROM DB

But you’d be wrong.

No, the people who created SQL thought a syntax with a little richer flexibility would do the trick.  Why limit ourselves to two states when multiple states will do?

SELECT CASE field WHEN 2 THEN "content true"     ELSE "content false" END
    FROM DB

In fact you can have multiple WHEN conditions in your code

SELECT CASE field
    WHEN 1 THEN 'One'
    WHEN 2 THEN 'Two'
    WHEN 3 THEN 'Three'
    END FROM DB

You can also use multiple fields

SELECT CASE
   WHEN field1 = 1 THEN 'field one'
   WHEN field2 = 2 THEN 'field two'
   ELSE 'Something else'
   END FROM DB

Other Related Items:

Who Moved My Cheese?: An Amazing Way to Deal with Change in Your Work and in Your LifeOutline Change can be a blessing or a curse, depending on your perspective. The message of Who Moved My Cheese? is that all can come to see it as a blessing, if they understand the nature of cheese a

Wilson Jones 362 Line Basic Round Ring View Binder, 3-Inch Capacity, 8.5 x 11 Inch Sheet Size, White (W362-49W)Looks good on the shelf or on the go. Customize for filing or presentations with a non-glare overlay on the spine and front and back covers. Use the round ring open and close triggers for easy access. Take advantage of interior pockets for extra storage.

Bounty Paper Towels, White, Regular Roll (Case of 30)Bounty Paper Towels, White, Regular Roll, this is one white you won't mind dirtying up. Whether it's muddy paw prints on the floor or soda spills on the table, new and improved Bounty has the strength, absorbency, and cloth-like durability to clean the mess with less.

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Related Post

• SQL – Filtering WHERE condition on two rows
• Random in SQL – SQL For Programmers
• SQL CURSOR Performance – SQL For Programmers
• SQL CURSOR – SQL For Programmers
• Temporary Tables – SQL For Programmers

Bookmark to:

Hide Sites

2 Responses to “SQL SELECT CASE Instead of IIF”