I used to to for a automotive engine and transmission re-manufacturing company. THey rebuilt transmissions (around 800 per week) for Chrysler and rebuilt engines for sale to the public....

We replace the characters with a blank or space depending on what they are. We remove them because they cause issues when exporting to Excel from reporting services.

Try this for the Tab and pipe

Select * from myTable where MyField Like '%' + char(9) + '%' or MyField Like '%' + char(124) + '%'

The Number is the...

When looking for a range, is this according to the ascii table? For example:

where FixSubject like '%[' + Char(1) + '-' + Char(11) + ']%'

Does this find everything...