If I have a query like

Select * from table1 WHERE ColVal IN (Select AllVals from table2)

Is it not better to have the following instead? It will bring in those values that have trailing and leading spaces also.

Select * from table1 WHERE LTRIM(RTRIM(ColVal))

IN (Select LTRIM(RTRIM(AllVals)) from table2)