Pattern Matching

LIKE :- The LIKE predicate allows for a comparison of one string value with another string value, which is not identical. This is achieved by using wildcard characters. Two wild card characters are give bellow.
1) % à percent sign matches any string.
2) _ à Underscore sign matches any single character.

Ex:- 1) select * from vision where na like ‘r%’;
2) select * from vision where na like ‘_a%’;