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

Share

Share

Rate