Forum Discussion
Attempting to identify carriage return line feed character in SQL field
I have a column on a table that appears to have some form of the carriage return/line feed character in the first byte. I have discovered this when I concatenated this with other related text columns...
Hi
For info, Chr(10) is line feed & Chr(13) is carriage return. See ASCII Codes Table
OP may have to switch to text import and possibly add a column updating to only specific ASCII characters - Shift+Space (used to be called a hard space) comes to mind.