![SQL SERVER – How to insert a string value with an apostrophe (single quote) in a column | SQL Server Portal SQL SERVER – How to insert a string value with an apostrophe (single quote) in a column | SQL Server Portal](https://raresql.files.wordpress.com/2013/06/singlequotes1-11.png)
SQL SERVER – How to insert a string value with an apostrophe (single quote) in a column | SQL Server Portal
![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
![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
![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)