Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Is it possible to eliminate embedded spaces?

Author  Topic  Pwayneb Starting Member 2 Posts Posted - 2001-06-27 : 17:51:21 For example, one of the values in my Address column is: '544 Redwood Drive Suite 100' I want to eliminate the embedded multiple spaces so that it appears as: '544 Redwood Drive Suite 100' Is it possible to do this with a query? Thanks in advance, Wayne