SQL Switch/Case in ‘where’ clause

by 
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

More Related Contents:

  1. Query SyntaxError [closed]
  2. PostgreSQL Crosstab Query
  3. How do I perform an IF…THEN in an SQL SELECT?
  4. Can I use CASE statement in a JOIN condition?
  5. “CASE” statement within “WHERE” clause in SQL Server 2008
  6. OR is not supported with CASE Statement in SQL Server
  7. GROUP BY + CASE statement
  8. Are a CASE statement and a DECODE equivalent?
  9. How do I use properly CASE..WHEN in MySQL
  10. Case in Select Statement
  11. SELECT query with CASE condition and SUM()
  12. Using Alias In When Portion of a Case Statement in Oracle SQL
  13. Return number from Oracle Select statement after parsing date
  14. T-SQL: Using a CASE in an UPDATE statement to update certain columns depending on a condition
  15. Dynamic order direction
  16. Simple way to transpose columns and rows in SQL?
  17. GROUP BY with MAX(DATE) [duplicate]
  18. How can I delete using INNER JOIN with SQL Server?
  19. In MySQL queries, why use join instead of where?
  20. Why are relational set-based queries better than cursors?
  21. join comma delimited data column
  22. How to round an average to 2 decimal places in PostgreSQL?
  23. How to get second largest or third largest entry from a table [duplicate]
  24. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  25. Update with Join query in Oracle
  26. How to create timestamp column with default value ‘now’?
  27. Autoincrement in oracle to already created table
  28. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  29. IIS connecting to LocalDB
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment