How to find fields containing the TAB character in SQL Server

December 27, 2023 by Tarik

RTRIM CHAR columns. like this:

SELECT        *
FROM          MyTable 
WHERE        (RTRIM(Field1) LIKE '%' + CHAR(9) +  '%')