What is the reason why SQLServer lrtrim () can't drop the space?
What this article shares to you is about the reason why SQLServer lrtrim () can not drop the blanks. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Without saying much, let's take a look at it.
Reason: there is a carriage return or newline character in the middle, so replace this symbol first
LTRIM (RTRIM (REPLACE (REPLACE (APowerchar (13),'), char (10),')) LTRIM (A)-- to replace the space on the left RTRIM (A)-- to replace the space on the right REPLACE (APowerchar (13),')-- to replace the carriage return with''REPLACE (APowerchar (13),'')-- to replace the newline character with''is why SQLServer lrtrim () can't drop the space. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.