I want to write a query for searching particular text in long string:
Like: column 1 have data : This is Dotnetfunda in DotNet
Collumn 2 have data: This is dotnetfunda in dotnet. It is good.
Now when I enter Dotnetfunda in text box the all result will be show: This is Dotnetfunda in DotNet.
And when we enter dotnetfunda the result will be shown: This is dotnetfunda in dotnet. It is good.
Any Idea for such type of query: