check if string contains substring sql
Declare @mainString nvarchar(100)='Amit Kumar Yadav'
---Check here @mainString contains Amit or not, if it contains then retrun greater than 0 then print Find otherwise Not Find
if CHARINDEX('Amit',@mainString) > 0
begin
select 'Find' As Result
end
else
select 'Not Find' As Resultsql where contains
SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
OR column1 LIKE '%word2%'
OR column1 LIKE '%word3%'t_sql contains
SELECT * FROM table WHERE Contains(Column, "test");sql where contains part of string
-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
