This discussion is archived
0 Replies Latest reply: Aug 6, 2009 10:29 AM by 571062 RSS

One SQL statement

571062 Newbie
Currently Being Moderated
I have a text column with values like listed below:
text_column
Today is my birthday.
I have a dog and a cat.
....
How can I use one SQL statement to get rid of the multiple spaces and replace with just one space?

THANKS a million.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points