Answers for "search for string sql"

sql where contains

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

Posted by: Guest on January-22-2020

locate sql server

SELECT CHARINDEX('b','ab') //returns 2

Posted by: Guest on May-26-2020

Code answers related to "search for string sql"