Jump to content

Pls. help. Updating 1000 rows and removing extra spaces.


seeknowledge

Recommended Posts

Hi there,

 

This seems to be a great place to be. Ok I'll quickly get to the question :) I am working on a SQL Server 2008 Database table that has over 1000 rows.

 

I need to update rows by removing extra spaces between words. For example:-

 

MyColumnName
This    is simple    Data in   a row
This is    the    second row

 

As you can see, this above 2 rows have extra spaces in them. How do I update this column to have only a single space between words.

 

What update query shall I use? Do I use stored procedure or something or any other trick?

 

Kindly reply.

 

All comments and feedback are welcomed :)

 

Thank you! :)

Perhaps an UPDATE query with the REPLACE() function? Replace two spaces with one space, and repeat the query until no further rows are affected? Maybe? As a non-MSsql user, that's the only thought I have at the moment . . .

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.