/SQL/Check if string contains substring sql

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 Result

Sql where contains part of string

-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.

Source: stackoverflow.com

Check if string contains substring sql

SELECT * FROM [table]

WHERE [field] LIKE  concat ('%',[fieldname],'%')

Similar codes

0 vote313 views1 answer
Mysql coonect sample code
SQL
0 vote305 views4 answers
How to drop all tables in sql
SQL
4 votes318 views2 answers
Oracle last day of month
SQL
4 votes310 views1 answer
Sql group by year
SQL
0 vote298 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
49 votes392 views6 answers
Mysql add column to table
SQL
17 votes320 views6 answers
Get last record in sql
SQL
0 vote310 views1 answer
Add column to table with default value plsql
SQL
0 vote296 views1 answer
Sql developer format sql
SQL
0 vote343 views1 answer
Trigger vérifier stock
SQL