Like cluase allows you to match a character string found in a column to a specified pattern in the where clause
lets take an example to better understand its wild cards
How to use like in where clause
DECLARE@TTABLE (charcvarchar(20))
INSERTINTO@T(charc)
VALUES(‘Cat’)
,(‘hat’)
,(‘that’)
,(‘at’)
,(‘c’)
,(‘a’)
Percent % :
Underscore _ :
Square Brackets [] :
Caret:
Sqljunkieshare 
Having read this I believed it was really enlightening.
I appreciate you spending some time and effort to put this information together.
I once again find myself personally spending way too much time both reading and leaving comments.
But so what, it was still worth it!