yanci1179
asked on
update statement that will remove carriage return from field
I have some fields that have a carriage return within the field, this is throwing off my export. Is there an update that I can do that will update all the fields to remove the carriage return?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx!! how would you include in the where clause only those with feed or carriage returns?
yanci1179,
No need--the rows with no CR or LF will go unchanged.
Regards,
Patrick
No need--the rows with no CR or LF will go unchanged.
Regards,
Patrick
ASKER
thank you so much, you solved so many headaches!!
yanci1179,
Glad to help :)
Regards,
Patrick
Glad to help :)
Regards,
Patrick
SET SomeColumn = REPLACE(SomeColumn, CHAR(13), '')