seeknowledge Posted February 21, 2011 Share Posted February 21, 2011 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! Quote Link to comment https://forums.phpfreaks.com/topic/228369-pls-help-updating-1000-rows-and-removing-extra-spaces/ Share on other sites More sharing options...
Pikachu2000 Posted February 22, 2011 Share Posted February 22, 2011 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 . . . Quote Link to comment https://forums.phpfreaks.com/topic/228369-pls-help-updating-1000-rows-and-removing-extra-spaces/#findComment-1178234 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.