I probably didn't compose my original post very well. It is a FileGeoDB so:
SELECT * FROM Taxlot_Taxpayers WHERE
Taxlot.MapTaxlot LIKE '%R%'
Does return all records in that field that contain an R.
What I have now (which works) is:
SELECT * FROM Taxlot_Taxpayers WHERE
Taxlot.MapTaxlot LIKE '%R%' OR Taxlot.MapTaxlot LIKE '%W%' OR Taxlot.MapTaxlot LIKE '%T%'
What I want is a shortend version like this ( Which should work with SQL):
Taxlot.MapTaxlot LIKE '%[RWT]%'
It doesn't matter that much with this example, but if I end up with a lot of values it becomes a pain (and is harder to read as well).