SQL Server wildcard (used for like queries)

Wildcard	Description	Example
%	Any string containing zero or more characters.	Where title like '% Computer %' searches for all titles containing the word computer in any location of the title.
_ (Underline)	Any single character.	Where au_fname like '_ EAN' searches for the names of all four letters ending with EAN (such as dean and Sean ).
[]	Specifies any single character in the range ([a-f]) or set ([abcdef.	Where au_lname like '[C-P] Arsen' will look for the author's surname that ends with arsen and starts with any single character between C and P, such as Carsen, Larsen, Karsen, and so on.
[^]	It does not belong to any single character in the specified range ([a-f]) or set ([abcdef.	Where au_lname like 'de [^ L] %' searches for the last names of all authors whose names start with De and whose subsequent letters are not l.