I have a situation where data in a field contains CrLf characters. Code has been in place for a couple of years and many records have been affected.
The question is:
Should I add code to catch the CrLf characters at the field level?
Should I add code to catch and possibly correct the data before it is uploaded to SQL?
Should I modify the upload to catch CrLf characters and possibly correct the data in the upload procedure?
Whichever approach is more appropriate, how do I identify CrLf characters and then correct it.