/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

14 votes159 views2 answers
Oracle add attribute to table
SQL
0 vote102 views1 answer
How to set field to null in sql
SQL
0 vote142 views1 answer
Mysql search multiple tables
SQL
0 vote156 views4 answers
Best data type to represent money in mysql
SQL
1 vote157 views1 answer
Select from describe sql
SQL
2 votes145 views1 answer
Oracle virtual column
SQL
0 vote149 views1 answer
Mysql sleep connections
SQL
0 vote164 views2 answers
Enter into postgresql database,create user and grant Access
SQL
2 votes186 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote153 views1 answer
Create table split string function in sql server
SQL