????SQL?????????
????SQL???????????like??????????SQL???????????ο????￡?
????1??LIKE'Mc%' ??????????? Mc ?????????????????? McBadden????
????2??LIKE'%inger' ??????????? inger ??β??????????????? Ringer??Stringer????
????3??LIKE'%en%' ?????????κ?λ?e?????? en ??????????????? Bennet??Green??McBadden????
????4??LIKE'_heryl' ??????????? heryl ??β?????????????????????? Cheryl??Sheryl????
????5??LIKE'[CK]ars[eo]n' ?????????????????Carsen??Karsen??Carson ?? Karson???? Carson????
????6??LIKE'[M-Z]inger' ????????????? inger ??β????? M ?? Z ???κε?????????????????????? Ringer????
????7??LIKE'M[^c]%' ??????????? M ???????????????????? c ?????????????MacFeather????
??????????????????????????? zipcode_key ??????????? zipcode ?в??????????????????ж???? zipcode_key ????????????????? % ???????????????????????е?????С???????в??????????????????????????????С????????????????????????????????????д??????????????
????sql = "select * from zipcode where (address like'%" & zipcode_key & "%') or (city like'%" & zipcode_key & "%') or (province like'%" & zipcode_key & "%') order by province??city??address