View Single Post
 
Old December 1st, 2005, 12:47 PM
robprell robprell is offline
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry this does not make sense to me. Why do you want to use a case statement in a where clause. Why not just use the same type of where logic you were using and eliminate the case entirely. If you stick to "and" & "or" logic entirely (no case) your live will be much happier. There is nothing in your case you can't do with and/or.