![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_split014.jpg)
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
![How to remove special characters like TAB, Carriage Return, and Line Feed characters from string in SQL Server – SQLZealots How to remove special characters like TAB, Carriage Return, and Line Feed characters from string in SQL Server – SQLZealots](https://latheeshnk.files.wordpress.com/2020/03/replace_baddata1.jpg)
How to remove special characters like TAB, Carriage Return, and Line Feed characters from string in SQL Server – SQLZealots
![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)
Removing part of string before and after specific character using Transact-SQL string functions | Basit's SQL Server Tips
![SQL SERVER - How to Remove All Characters From a String Using T-SQL? - SQL Authority with Pinal Dave SQL SERVER - How to Remove All Characters From a String Using T-SQL? - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/c/chars.jpg)