Error when using Replace and Update

I am trying to replace the carriage returns and line feeds from a varchar field with a <br> tag using the following query:

UPDATE tmpJobImport
SET job_desc = replace (replace(job_desc, char(10),''), char(13), '<br>')

I receive an error that says "string or binary data would be truncated" and cannot update the field. The field is large enough to hold the update and I can run the exact command in a select statement and get the results back.

SELECT REPLACE(REPLACE(job_desc, CHAR(10), ''), CHAR(13), '<br>') AS testField
FROM tmpJobImport

Any thoughts on why I might be getting this error? I can run the update with just a '<>' or 'br', but not '<br>'.

Thanks,

Dean

Hi,

What is the datatype of job_desc?

You get this error because <br> might take extra space than the ordinary string.

Try changing the width of the job_desc and execute it again.