Like Operator Examples

Example 1

Select *
  From customers c
Where c.name Like '%CORPORATE%' ;

Example 2

Select *
  From customers c
Where c.name Like 'CORP%' ; -- begin with CORP

Example 3

Select *
  From customers c
Where c.name Like '%CORP' ; -- end with CORP


Example 4

Select *
  From customers c
Where c.name Like '_C%' ; -- second letter start with C

Example 5

Select *
  From customers c
Where c.name Not Like '%CORPORATE%' ;

Example 6

Select *
  From customers c
Where upper(c.name) Like '%CORPORATE%' ;