![T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions - TechNet Articles - United States (English) - TechNet Wiki T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions - TechNet Articles - United States (English) - TechNet Wiki](http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/8322.results.png)
T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions - TechNet Articles - United States (English) - TechNet Wiki
![SQL SERVER – TRIM – How to remove leading and trailing characters/Spaces from string | SQL Server Portal SQL SERVER – TRIM – How to remove leading and trailing characters/Spaces from string | SQL Server Portal](https://raresql.files.wordpress.com/2013/05/lefttrim1-1.png)
SQL SERVER – TRIM – How to remove leading and trailing characters/Spaces from string | SQL Server Portal
![Javarevisited: How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example Javarevisited: How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example](https://4.bp.blogspot.com/-JNt4P6Qengo/W8yFj-hwJrI/AAAAAAAAMcc/TInWL6HtM6Q3Y5EmFlwr_40PZW1EDOpKACLcBGAs/w1200-h630-p-k-no-nu/How%2Bto%2Bremove%2Bwhitespace%2Bfrom%2BString%2Bin%2BSQL%2BServer.png)
Javarevisited: How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example
![T-SQL 101: #46 Using LEFT, RIGHT, and SUBSTRING to extract substrings in SQL Server - The Bit Bucket T-SQL 101: #46 Using LEFT, RIGHT, and SUBSTRING to extract substrings in SQL Server - The Bit Bucket](https://blog.greglow.com/wp-content/uploads/2019/12/Substring_01.png)