Get the App
SLTechnology News&Howtos  ›  Database  › 

What is the reason why SQLServer lrtrim () can't drop the space?

Shulou Source: shulou.com Published: 2022-05-31 12:54:31 11月16日 Update

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.

Tags: Spaces reasons newline characters more knowledge articles practical right that is work meetings articles look knowledge points symbols industry details information information channels follow part Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Apple Huawei Xiaomi MySQL MariaDB