Like Predicate

Used with T-SQL Wild Cards, the LIKE predicate looks at a Wild Cards string and runs the Regular Expressions pattern matching operation.

SELECT Name
FROM Person
WHERE Name LIKE 'Jo*' -- wild card matching on strings
/*
	Result would be any of these:
	John
	Jon
	Johnny
	Jonny
	Etc.
*/