![Removing part of string before and after specific character using Transact-SQL string functions | Basit's SQL Server Tips Removing part of string before and after specific character using Transact-SQL string functions | Basit's SQL Server Tips](https://basitaalishan.files.wordpress.com/2014/02/tsql_split022.jpg?w=600)
Removing part of string before and after specific character using Transact-SQL string functions | Basit's SQL Server Tips
![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
![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)
T-SQL 101: #46 Using LEFT, RIGHT, and SUBSTRING to extract substrings in SQL Server - The Bit Bucket
![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)