How to compare a variable against multiple values in MSSQL

[Anil Verma]

How to compare a SQL variable against multiple values:

Here is the scenario;

Declare @JobTitle varchar(10)

Select @JobTitle = JobTitle from tableName where xxx=xxx

Now I want to compare @JobTitle value against multiple strings without using OR in the IF statement?

if @JobTitle = 'AAAAA' OR @JobTitle = 'BBBBBB' OR @JobTitle = 'CCCCC' ......

instead of using multiple OR, is there any other way to accomplish this?

[gpl]

Use IN, for example

@JobTitle IN ('AAAAA', 'BBBBBB', 'CCCCC')