Check a string present in another string in Sql Server

In this post we will show you how to check a string present in another string in Sql Server. We can check a string present in another string or not using CharIndex which is a built in Sql-Server method.

Declare @string Varchar(20);
Set @string = 'Some string';

Select CHARINDEX('string', @string)

The result will be 6.

If the string is not present in another string it will return 0.

Please like and share the blog if you find it helpful and interesting.

Related articles

• Change database runtime when using ADO.Net 
• Using UNC path for Storing and Retrieving Files in ASP Net 
• Introduction to the .Net platform 
• Dot Net : All types are derived from System.Object 
• Definition of Common Type Specification (CTS) and Common Language Specifications (CLS)
• All you want to know about Common Language Run Time (CLR) 
• How to Integrate CKEditor in Asp Net Web Application 
• Raddish : New Node.js framework 
• All about MongoDB Collections 
• Print Screen in Asp Net Web Application