Remove extra spaces and CR
Posted on 2007-07-25
Request assistance with correcting a database table after cut/paste and other import operations were done. I have sporadic character returns and square characters everywhere.
Please look at the following: www -dot- thebooths -dot- org/1.jpg for a better example.
I have been using the following script, but it doesn't seem to work very well.
SET TestResults = REPLACE(TestResults, CHAR(127), Char(13) + char(10))
I also have trouble identifying the square in particular.
anyone have any ideas how to fix this?
These particular tables are varchar and will not be used on a web platform.