Declare @JobTitle varchar(10) Select @JobTitle = JobTitle from tableName where xxx=xxx
if @JobTitle = 'AAAAA' OR @JobTitle = 'BBBBBB' OR @JobTitle = 'CCCCC' ......