Hi Experts ,
We need to search in database with the record contains particular Data in it e.g. name column could search for all words that contains 'jon' in it. Is this correct query
SELECT Name FROM Person WHERE Name LIKE '%Jon%'
Open in new window
yes it is correct.
It will look for the word where it contains "Jon" in the Name column.