SQL Server 2008: How to find trailing spaces August 12, 2023 by Tarik You can find trailing spaces with LIKE: SELECT col FROM tbl WHERE col LIKE '% '