Case expression in where clause

CASE is easiest to understand in the context of an example: Thanks for share the solution!

case expression in where clause

You can download attachments. MMartin1 Posted 8 years ago 1215738. Submit your solution!

case expression in where clause

Please Sign up or sign in to vote. You can't delete your own posts. Add your solution here. Mode Analytics.

Updated 23-Apr-18 12: But what if you also wanted to count a couple other conditions?

case expression in where clause

Using the previous example, you might first write:. I think the reply from frfernan is your best bet. Patrice T 23-Apr-18 18: You can't edit your own topics.

Case statement in Where Clause – SQL Server – Conditional Where clause

You can't send private messages. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Prabhat Sinha 1,394 11 24.

You can't edit other topics. Encode HTML. You can't delete other events.

Case statement in Where Clause SQL SERVER

Here is the query: Case expression , not statement... You can't post events.

case expression in where clause

Sign In. Stack Overflow works best with JavaScript enabled. Case in where clause.