I previously posted on the LTRIM and RTRIM inability to remove certain not printing whitespace characters which can sometimes cause problems. I have updated the SQL page with a User Defined Function (UDF) which can be used in queries or in a stored procedure. I have also included a link to the Code Project article.
LTRIM RTRIM don’t always work –UDF (UPDATED)
- Leave a comment