I have a number of columns in my dataset one/or more of which I believe might have an embedded special character such as a CR or LF. I have tried using the following in my query:
patindex('%' + char(13) + '%' , texfield) > 0 to no avail. I have also tried charindex with the same result.
I know that the special character is there because when I export the data out to text somewhere along the way the records gets truncated into two.
I would like to be able to locate this special character and strip it out. Any suggestions.
My next step is to write a VB program to go through the dataset.