View Single Post
  #3 (permalink)  
Old January 11th, 2011, 10:03 AM
kevlangdo kevlangdo is offline
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Add a Case expression to a Where clause

Here are a couple of examples on how to add a Case expression to a where clause. For more complex case expressions or boolean operations, you could use a scalar function and just return a value:

How to Add a Case expression to a Where clause using a function
Reply With Quote