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.
While it's good to know you found a solution, questions remain. Sometimes, it can be useful to share solutions so that others looking for help can possibly benefit. Would that be possible? Can you share this "online vb script" and how you used it?
Also, "...It didn't seem to work..." doesn't tell us much about the problem in SQL. How did you attempt to implement it in SQL and what happened -- or didn't happen? Or was there an error?
Again, while it's helpful to share that you found a solution, it would be nice to share it as well, in case someone else can benefit later.
Thank you.