![sql server - SQL - If string in a column from one table contains string in column from joined table - Stack Overflow sql server - SQL - If string in a column from one table contains string in column from joined table - Stack Overflow](https://i.stack.imgur.com/n5XJA.png)
sql server - SQL - If string in a column from one table contains string in column from joined table - Stack Overflow
![sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow](https://i.stack.imgur.com/3lBzl.png)
sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow
![sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow](https://i.stack.imgur.com/ms6R7.png)
sql server - SQL CONTAINS function do not show records with the word 'under' even using u as keyword search - Stack Overflow
![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)