Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Replace multiple spaces with single spaces (See related posts)

This work is licensed under a Creative Commons Attribution 2.5 License.
WHILE CHARINDEX('  ', @string) > 0 SELECT @string = REPLACE(@string, '  ', ' ')


where @string is the parameter or variable.
to sql sql_server sql-server SQLServer by rgedwards on Thu Sep 29 19:22:32 -0400 2005

You need to create an account or log in to post comments to this site.


Click here to browse all 5140 code snippets

Related Posts