seeknowledge

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!