Quantcast SQL Trim

SQL Trim

by Neon Quach 3. September 2011 21:11

Function removes white spaces (incl. ones in the middle). For Microsoft SQL Server 2005/2008

Trims:
1) Leading spaces
2) Trailing spaces
3) White spaces of any length in the middle. Where LTRIM(RTRIM()) don't succeed

Plain, simple, easy.

Add this function to your database and you're ready to go.

Included:
- CREATE FUNCTION script
- Test/sample script

Download: http://sqltrim.codeplex.com/

Tags: , ,


Categories: codeplex | download | sql

dotnetkicks dotnetshoutout dotnetburner servefault fairfeeds pimpthisblog yahoo buzz google buzz
Permalink | Comments (0)
blog comments powered by Disqus

About me

I'm currently employed as Software developer at devinition.com and also a Microsoft Certified Technology Specialist (MCTS), Microsoft Certified Professional Developer (MCPD) in Net Framework 2.0 and 3.5: Web Applications and MCTS .NET Framework 3.5, ADO.NET Applications

Powered by BlogEngine.NET 2.5.0.5 - Eco Theme by n3o Web Designers