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