![Most effective way to check sub-string exists in comma-separated string in SQL Server - Stack Overflow Most effective way to check sub-string exists in comma-separated string in SQL Server - Stack Overflow](https://i.stack.imgur.com/4ZCQk.png)
Most effective way to check sub-string exists in comma-separated string in SQL Server - Stack Overflow
![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
![Selecting Rows from Comma-Delimited String in SQL Server | Notes About SQL Server and .NET Development Selecting Rows from Comma-Delimited String in SQL Server | Notes About SQL Server and .NET Development](https://sqlanddotnet.files.wordpress.com/2015/02/select-rows-from-string-bad-truncation.png)
Selecting Rows from Comma-Delimited String in SQL Server | Notes About SQL Server and .NET Development
![SQL String Function SUBSTRING | How to extract a substring from a string in SQL | #SUBSTRING() - YouTube SQL String Function SUBSTRING | How to extract a substring from a string in SQL | #SUBSTRING() - YouTube](https://i.ytimg.com/vi/gP4DVLYaPDc/maxresdefault.jpg?sqp=-oaymwEmCIAKENAF8quKqQMa8AEB-AH-CYACrAWKAgwIABABGGUgZShlMA8=&rs=AOn4CLDdL89E6qKmj4AxYKA7NY-8LAO6Ww)