The rtirm/ltrim or alltrim didn't work either, for some reason I dont think functions will work in the where statement. The only other way I can see this working is if I go back and trim all of my data in the database unless there is another way.
Thanks Kelly