Lynn Emery

Lynn Emery

  • NA
  • 47
  • 56.5k

Case Statement

Mar 11 2013 10:16 AM
Hi I am trying to add a virtual field via a substring, however I am having difficulties when trying to compare more the one substring.
For example

SELECT        location, sales, Month, Year,  CASE WHEN Substring([location], 1, 8) = '12345678'  OR '24578914' THEN 'Location A' END AS  Storage
FROM             Sales

Does anyone know how to compare more than one substring value within a statement rather than creating a case for each.


Answers (2)