Here's an alternate way of removing multiple white spaces by using the REPLACE command.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2005-03-08 (first published: 2005-02-22)

147 reads

Blogs

Do you run SQL Agent Jobs in your environment? Do you know what is...

When I got a new machine, I had SQL Clone on my old machine,...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Hi I want to convert table content which contain the json values in the...

Hello, I faced very strange issue. When I try from management studio to put...

I'm new to SQL and I'm struggling to return a result set which I...

Visit the forum

See possible answers