My problem is unwanted concatenated carriage returns (char(13)) and line feeds (char(10)) in tables. I would like to create a stored procedure to search for and delete the concatenated characters. I have managed to track the problem linking the table into MS Access but I would like to be able to do it in SQL Server. Any ideas on possible queries to run in SQL Server to start me out? All help will be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to delete a concatenated char(13) + char(10) using an sp?
- Thread starter tjohnsb
- Start date
Try this:
[tt]update mytable
set mycolumn = replace(mycolumn, char(13), ''),
mycolumn = replace(mycolumn, char(10), '') [/tt]
Robert Bradley
Do you have too much money? Visit
[tt]update mytable
set mycolumn = replace(mycolumn, char(13), ''),
mycolumn = replace(mycolumn, char(10), '') [/tt]
Robert Bradley
Do you have too much money? Visit
- Status
Similar threads
- Locked
- Question
