Assuming declare is required, the following 41 results were found.
Trim in T-SQL and SSIShttp://mail.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE @EmployeeStr = 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE'...