Cause Analysis for SQL Server ltrim (rtrim () to eliminate spaces, ltrimrtrim

Cause Analysis for SQL Server ltrim (rtrim () to eliminate spaces, ltrimrtrim

Cause: There is a carriage return or line break in the middle, so you must replace this symbol first;

LTRIM (RTRIM (REPLACE (A, char (13), ''), char (10),'') LTRIM () --- change left space RTRIM (A) --- change right space REPLACE (A, char (13), '') ---- REPLACE carriage return with'' REPLACE (, char (13), '') ---- Replace the linefeed''

Summary

The above is an analysis of the reason why SQL Server ltrim (rtrim () cannot remove spaces. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in time!