SQL Switch/Case in 'where' clause

Question

I attempted searching around, however, I couldn't find anything that would help me out.

I'm attempting to do this in SQL:

I know that I shouldn't have to put '= @locationID' at the end of each one, but I can't get the syntax even close to being correct. The SQL keeps on complaining about my '=' on the first WHEN line...

How will I do this?

Answer 1

You can use the following code:

declare @locationType varchar(50);
declare @locationID int;

SELECT column1, column2
FROM viewWhatever
WHERE
@locationID = 
  CASE @locationType
      WHEN 'location' THEN account_location
      WHEN 'area' THEN xxx_location_area 
      WHEN 'division' THEN xxx_location_division 
  END

Looking for a SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.