![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
![Removing part of string before and after specific character using Transact-SQL string functions – SQLServerCentral Removing part of string before and after specific character using Transact-SQL string functions – SQLServerCentral](http://basitaalishan.files.wordpress.com/2014/02/tsql_split014.jpg)
Removing part of string before and after specific character using Transact-SQL string functions – SQLServerCentral
![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_02.png)
T-SQL 101: #46 Using LEFT, RIGHT, and SUBSTRING to extract substrings in SQL Server - The Bit Bucket
Error: General ODBC error: [Microsoft] [ODBC SQL server Driver] String Data Right truncation, Native error: 0 - when processing transactions
![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)