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  

0
6
Amziraro 100 points

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

0
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
mssql find where contains character in string sql check if string is in string sql check string contains only sqpces sql search string contains sql if contains letter check if contain a word sql check string sql contain letter sql query for contain string how to check contains in sql sql if variable contains string sql variable contains string sql query check if value contains string sql contains strings sql contains letters sql check column contains string sql if sstring include substring select string that contain substr sql sql query all text which contain substring sql where value contains mssql if string contains character check substring in sql column sql where contains letters sql select where contains string check if a varchar coninatins a substring sql find if string contains substring sql sql check substring if string contains sql server sql where string contain how to find if string contains string in sql if string contains sql how to check if a field contains a string in sql check string for substring sql sql where srt contains part of string sql text contains sql string conatins hana sql when string contains check where sting containg specicif char in string in sql string contains sql query string contains sql how to check the part of string in sql with another string ms sql check if string contains substring ms sql if string contains check substring in soracle sql check for a substring in sql check a string in a column contains another string sql sql query that contains text sql query column contains string sql where contains text SQL, string doesn't contain substring sql search for substring in string check for string in another string in sql how find record where column contains substring sql how to check if column contains substring sql t sql where parameter string contains check if string is contained in sql sql for string contains sql select string contains character sql where column contains a substring sql string contains caracter where contains string sql where string contains WORD STARTING WITH LETTERS sql column contains string sql sql contains substring sql name contains sql includes in string contains string command sql sql query select where string contains if string contain text in SQL sql where string contains % how to check if a string contains a substring in sql sql when string contains character sql query contain string checking substring in sql containt string in sql if any part of a string mathces sql select where column contains string sql sql query string contains check if string is substring of another sql 2014 like check if string is substring of another sql 2014 check if string is substring of another sql 2012 check if string is substring of another sql test if substring in string sql check for sub string sql check if a substring is part of a string sql server sql select where substring contains sql string contains letters how to search for a field that contains a specific string in sql sql server check if string contains characters sql if string in string check if substring in string sql server sql query contains text sql check if string contains substring case sql check if name contains substring select sql where string not contains sql select column that contains string sql where text contains substring function in sql contains how to check if string contains a word in sql check if row contains string sql sql select column name contains string sql check if string present how to check trings cointaining substrings in sql sql query contains string where sql string contains sql expression contains string check if word is in string sql server sql check if any value contains how to check contains in sql query sql where contains character sql where column contains substring sql check if word contains sql where substring contains sql check if something contains string sql query contains character sql contains in string sql includes string sql where contains string sql match string even if substring start where column contains string sql check if a string contains a character sql check substring in sql check substrings in sql string contain sql sql if a string has a substring using where how to select the elements in sql if a string has a substring using where how to select the elements in sql if a string has a substring sql select if column contains string how to check if a string contains a word in sql sql server check if string contains letters sql select if contains substring sql see if field is substring sql select if text contains sql like contains string sql string contains ' sql find if string contains sql check if cell contains string sql where contains a word how to check string contains specific characters in sql sql match any part of string sql where string contains character test to see if field contains string sql sql query to check if substring is in string sql for contains a string sql where field contains string sql server check if string contains word sql server search contains string sql check for substring sql select where contains substring in sql statement where statement check the a specifick substring? t sql string contains check substring in sql server sql select string contains check if a column contains a substring sql sql check that string contains letters sql check if contains or sql query string contains sql where a string contains sql value contains string sql contains part of string sql query where something contains sql where contains char sql query check if string contains letters sql server where contains string check if value contains string sql sql select everything where contains string how to check string using substring in sql query sql check if string does not contain letters if string in string sql string contains character sql how to check is string contains a word in sql sql query for text contains microsoft sql contains string sql server check contains string sql check contains SQL ST CONTAINS how to check if string contains substring sql check if column contains string sql how to check if string contains condition sql sql select where field contains character sql where string contains where condition to match all strings with a substring in sql contains string sql mmsss in sql if the given substring is part of the data sql contain string where value contains string sql how to grab something that includes a string in sql contains some string sql sql search record if contain string sql query to find all data that contains part of a string where string contains sql sql command for a string that contains part of a word sql command for a word contained in a string sql server check if substring exists sql server if column contains substring sql check if string contains any characters contains string sql server string contain check sql string contain another string sql how to now if an string contains a substring in sql how to check string contains word in sql orracle sql string contains '' contain in string condition in sql sql finding contains text contains a string sql sql string contains sql contains letter check for substring in sql sql where contains sql string firld contains sql where contains part of string sql query where contains string sql string contain substring if a character exists sql server sql match strings by substrings sql column text contains string sql check for surtain string sql query in condition for string contains contains word in sql sql value exists as substring sql contains string value sql to check a string only contains certain substrings and no others check string contain sql string contains sql & string contains query sql sql check if a string contains check if a string is present in sql query check if a string is present in sql sql select strings that contain sql select strings that containt SQL string contains substring SQL++ sql cointain stirng check if a string is a substring of another sql check if a string is a sub string sql sql get string that contains sql query where string contains how to check if a string contains a value sql sql check if string contains word sql contains text characters sql where column contains string SQL checking if string contains letter SQL TITLE CONTAINS SPECIFIC STRING sql contains string example string contains sql how to check if a string contains a substring in sql server substring that contains sql sql where substring in string t-sql contains string how to find a value if it contains substring in sql check substring is exist in sql sql if string contains word find if a particular letter exists in sql sql column contains string tsql check if field contains ' sql contains sql server check string content variable contains text sql select row with string sql mssql iff string contains mssql if string contains check if string contains sql server contains string sql sql select where string contains sql is string in string check message contains string qsl sql find all entries where substring is in string sql contains string sql if character in string value sql server if string contains check if string contains sql how to detect a sql operation from string sql check string contains sql string includes substring check if string contains value sql chaeck if string contains sql sql check if value contains check for a string in a cell sql server sql check if string contains another string if sql contains check if string contains string sql check is susbtring contains string sql string contains substring in sql t-sql string contains substring ms sql contains string string contains substring how to check if substring is string value in sql server check if the value is string in sql server check if string has substring check if string contains substring sql where substring contains numbers how to check for a substring in sql where string contains substring sql sql see if string contains substring sql if includes string mssql if string in how to find specific character in string in sql sql check substring against list of characters sql where text field contains how to check a string contain a specific character as begining SQL how to check a string contain a specific character in SQL check word in string sql sql check if string contain how to fetch the data where string contains substring in sql sql where part of string select rows containing a character sql string.contains in sql server csql string contains string contains sql server how to check string contains characters in sql server sql check if data contains character sql where row contains string check if contains sql check if word contains string one time sql sql query check if string contains check a string is like sql sql server string contains substring sql how to select rows where string is part of a column sql string contains string how to check for substring in sql in parameter values string how to check contains condition in sql check if a word appears at the end sql query sql to check some characters in string sql server check string contains sql check if substring is in like sql substring match check character exist in string sql server check character in string in sql server sql search a string that contains the char % sql server compare char in string contains in another string sql server check for substring sql server check if a string contains a substring dql contains string check if a table contains a part of an input sting SQL sql string does not contain substring sql check if substring not in string how to check if a string is equal to a substring in sql datagrip sql server string contains sql search string containted in other check if a string contains a substring sql how to check for contain in dql sql check if string contains mssql check if text in variable select query just with a part of string sql search for records with string substring a letter then check if match sql server sql server select a specific letter of string and verify string string contains mssql sql select matches substring word in string sql check word exist or not in sql server sql column includes string t-sql string contains sql server check if column contains character sql server check if column has text sql string contains character sql determine if a string is a real word sql substring presence sql char contains select row specific characters in string sql sql check if value in string sql server verifi string contais another string string contains in sql server sql row contains SQL Server value contains a string sql check if value contains string how to check if string contains character in sql how to check if a character exists in a string in sql check if text in text sql sql server string contains text sql query if for searching a string sql check a stirng in a row sql search if string contains why to check if sql query contains particular word TSQL STRING INCLUDE OTHER STRING sql server test if string contais another string sql server check if string contains if substring in string sql t sql check if string contains character if contain string sql check if a string contains substring in sql check whether it is string in sql how to check a part of word inside sql sql substring contains sql check if string contains substring check iff string contains '.' in sql n SQL string conntain " check if value contains word sql SQL statement to check a field has a number in the substring sql check if string is like sql string contains substring sql if string contains sql string has substring SQL STRING CONTAINS TEXT how to check if string contains a substring sql python how to check if string contains a substring sql how to check if a column contains a particular value in sql strings having a particular character in sql sql server if contains sql if contains c# check if sql contains sql check if string contains space charatceter in sql server sql check if a string contains a substring string contains in sql t sql string contains character sql server check if substring contains column value C# check if string is sql string sql if substring then sql server contains string verify if there character in string sql sql if contains string sql check if string contains letters tsql where string is in bigger string sql server check if data is string sql contains character example check if value in string sql match substring in sql but not a character match subnstring sql server sql if varchar contains word check string include special value in sql sql one string contains another check if string contains substring sql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source