One day, I wrote a SQL Script for client to synchronize data from one source database to multiple destination databases. I used LTrim, RTrim function to remove trailing spaces, but client informed me that it looks like the functions did not work.
I checked and found the cause as the screenshot below, the columns contains line delimiter characters, so the trim function could not work correctly.
I found out on the internet and found the way to handle this.
I based on the following article to handle the issue:
0 comments:
Post a Comment