CASE in a Where clause? 1

[ecobb]

Is is possible to use CASE in a Where clause? I'm trying to find an easier way to do the following. This is in a Stored Procedure I'm writing, rather than having 15 Select statements, is there some way I can have a dynamic where clause and just use 1 statement?

IF @Type = 'Sales'
  BEGIN
    Select IncidentID, IncidentDate, Customer, JobName, JobNumber
    From dbo.Incidents
    Where Sales = 1
    Order By IncidentID
  END

IF @Type = 'Quality'
  BEGIN
    Select IncidentID, IncidentDate, Customer, JobName, JobNumber
    From dbo.Incidents
    Where Quality = 1
    Order By IncidentID
  END

IF @Type = 'Production'
  BEGIN
    Select IncidentID, IncidentDate, Customer, JobName, JobNumber
    From dbo.Incidents
    Where Production = 1
    Order By IncidentID
  END

.....Several More of the same type SQL statements...

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[ptheriault]

Use 'OR'

Where (Sales = 1 and @Type = 'Sales')
OR (Quality = 1 and @Type = 'Quality')

...


- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[ecobb]

I hate it when I miss something so obvious!

Thanks, Paul!!!


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[ptheriault]

Don't worry about it. I did the same thing a week or so ago. I only knew the answer thank to Alex.
[small] props to AlexCuse[/small]

thread183-1358262

- Paul

- If at first you don't succeed, find out if the loser gets anything.