


        SQL has 2 widcards for Pattern matching
        
        1) % <- this will match Zero or more of ANY charactor
                select name from world.city
                where name LIKE 'A%'  <- starts with an 'A'
                select name from world.city
                where name LIKE 'A%n'  <- starts with an 'A' and with 'n'
                                           (watch out for training spaces)
                select name from world.city
                where name LIKE 'A%n%'  <- starts with an 'A' contains a 'n'
                
                
       2) _ <- this will match ANY SINGLE charactor  
                select name, country_code from world.city
                where country_code LIKE 'C_N'   <- starts with an 'C' the second charctor is anything
                                                   ends with 'N'
                select name from world.city
                where name LIKE '_a_s%' <- starts w/ any charactor, the second charactor is 'a'
                                           the third charactor is anything, the forth charctor is
                                           's' followed by any number (zero or more) of charctors
        
