Blog Post

How to remove new line character from string using SQL ?

,



In a varchar column some of the entries were showing space in the left side and even after using the LTRIM it was not getting removed. When I tried to  print the first character using the ASCI function it was showing 13 which is a new line character. it can be replaced by using the below code

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating