Replace duplicate spaces with a single space in T-SQL

by

Even tidier:

select string = replace(replace(replace(' select   single       spaces',' ','<>'),'><',''),'<>',' ')

Output:

select single spaces

More Related Contents:

  1. How can I remove duplicate rows?
  2. SQL Server: Examples of PIVOTing String data
  3. How do I create a unique constraint that also allows nulls?
  4. Using T-SQL, return nth delimited element from a string
  5. How do I get list of all tables in a database using TSQL?
  6. Get first day of week in SQL Server
  7. What is the use of GO in SQL Server Management Studio & Transact SQL?
  8. What is the significance of 1/1/1753 in SQL Server?
  9. SELECT DISTINCT on one column
  10. Using a if condition in an insert SQL Server
  11. Altering a column: null to not null
  12. Confused about UPDLOCK, HOLDLOCK
  13. Is there a way to simplify a NULL compare of 2 values
  14. TSQL Try / Catch within Transaction or vice versa?
  15. What is the maximum number of characters that nvarchar(MAX) will hold?
  16. TSQL Email Validation (without regex)
  17. Dynamic SQL results into temp table in SQL Stored procedure
  18. SQL Server Output Clause into a scalar variable
  19. How do I flush the PRINT buffer in TSQL?
  20. TABLOCK vs TABLOCKX
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. How do I select last 5 rows in a table without sorting?
  23. SELECT INTO a table variable in T-SQL
  24. T-SQL query to show table definition?
  25. How can I insert binary file data into a binary SQL field using a simple insert statement?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. T-SQL XOR Operator
  28. Include missing months in Group By query
  29. Random record from a database table (T-SQL)
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment