Hello,

I have in my select a column called "Mitarbeiter". I like to search for Mitarbeiter in ('SB','MS','BE') or Mitarbeiter not in ('SB','MS','BE')

The 'IN' or 'NOT IN' I want to change via a variable. (For SQL Server Reports)

so I come to the patindex and the change between <>0 and =0

But how to change it?

Olaf