Filtering Character Data - Wildcards used in LIKE patterns

Wildcard                                    Meaning

.................................................

%                                               Any string including an empty one

.................................................

_(underscore)                             A single character

.................................................

[<character list>]                      A single character from a list

.................................................

[<character range>]                 A single character from a range

.................................................

[^<character list or range>]        A single character that is not in the list or range

Note : 

1. ! is escape character.
2. col LIKE '%ABC%'
   SQL Server cannot rely on index ordering anymore

reference: reference:Training Kit Query SQL Server 2012,CHAPTER 3,page 69