How to Search particular Text in Sql-Server.

Answer:

With the help of CharIndex() sql-serverfunction,we can search any Text inside any String.

For Example:-

CHARINDEX('Vishal','Vishal Kumar');

Here,1st argument is our Search criteria and 2nd argument is our String to which charindex will find text.