SDU Tools: Trim Whitespace in T-SQL

Today’s post is about one of our free SDU Tools that helps you with what you’d think would be a simple task in T-SQL but isn’t.

TrimWhitespace is used to remove leading and trailing whitespace characters in T-SQL strings. As well as spaces, it will remove carriage returns, linefeeds, and tabs.

You can see its action in the image above.

You can also see it in action here:

For more information on our free SDU Tools for SQL Server developers and DBAs, follow this link:

http://sdutools.sqldownunder.com

 

Leave a Reply

Your email address will not be published. Required fields are marked *