![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/0871.leftright.png)
T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions - TechNet Articles - United States (English) - TechNet Wiki
![SQL Server - How to identify and replace "strange things" (hidden characters) in strings and tables - Dirceu Resende SQL Server - How to identify and replace "strange things" (hidden characters) in strings and tables - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2019/08/SQL-Server-Como-identificar-e-substituir-coisas-estranhas-em-strings-e-tabelas-4.png)
SQL Server - How to identify and replace "strange things" (hidden characters) in strings and tables - Dirceu Resende
![JavaScript basic: Create a string using the middle three characters of a given string of odd length - w3resource JavaScript basic: Create a string using the middle three characters of a given string of odd length - w3resource](https://www.w3resource.com/w3r_images/javascript-basic-image-exercise-63.png)
JavaScript basic: Create a string using the middle three characters of a given string of odd length - w3resource
![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?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
![Split double character of middle initial using CASE expression in a SQL Server stored procedure - Stack Overflow Split double character of middle initial using CASE expression in a SQL Server stored procedure - Stack Overflow](https://i.stack.imgur.com/85HaM.png)