Reputation: 9118
I am trying to replace leading and trailing new line chars from a string.
trim(field)
--> Doesn't remove new line chars
REPLACE(field,'\n','')
--> remove new line char in all the places, but I want only the leading or the trailing new line character.
Upvotes: 0
Views: 198