removing Square Symbol from sql text column
Posted on 2007-08-07
I'm using SQL 2005 and have a table with unique id and a text field:
From an import of an old system, there are lots of little square symbols that appear to act as line breaks when displayed on a web page.
I have tried replace scrips that look for char(10) and char(13) which remove something, but not the squares.
The characters are causing problems in my web application with the display in css.
I can remove them manually simply by copying into a text editor and then pasting back into sql. However, there are 400,000+ of these and I think that would be a little tedious.