I know this topic must have been covered but I have not had any luck finding a useful thread.
Some of the records in the database have a carriage return in the field which is showing up as a small square. This is breaking an application further down the line which is not under my direction. I need to remove all the returns in the field prior to sending the data down the line to the next application.
Does anyone know how to find these characters without having to dump the entire table out to word or excel?