Pattern Matching
To compare one string with another ‘like’ is used.For this, like will use wildcard characters that are
- % for matching string of any length
- _ for matching of single characters
Example
select * from customers where CustomerName like 'j%'-- search records startig with j
select * from customers where CustomerName like '%a'
-- search records ending with a
select * from customers where CustomerName like '%ye%'
-- search records which contain ye any where
select * from customers where CustomerName like '_a%'
-- search records which has second character a
