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...
I actually managed to use an online vb script to remove the 1st vbCr and vbLf after concatenating my data. It didn't seem to work when called from a SQL query but I can live with it in the context of my application. The concatenated data no longer has a blank line at the beginning.