SQL Filtering

[Mazkot]

Newbie to SQL so please bear with me.   Want to filter the records a user gets based on their login name.  I Have a field "SalesRep" in each of the tables I want to sync which works wonderfully for the individual sales reps, but now I have service techs which cover several sales reps territories.  I need help on how I can get them to be able to receive the correct salesrep records.

where SalesRep = '{MIRRORSYNC_USERNAME}'

Thanks

[Jesse Barnum]

It looks to me like it should work exactly as you have it. Is that not working?