I don't think location can't have two values in the same record. So 'AC' AND 'CA' is not possible. If you want 'AC' or 'CA' then MIXMATCH(location,'AS','CA') won't work as AS is not AC. Try MIXMATCH(location,'AC','CA') instead. And possibly you want MIXMATCH(TRIM(location),'AC','CA') instead of putting the trim on the outside.