Wild Card search for characters
Posted on 2013-01-18
I have a question about using the wild card in a query. I have a address table and there is a zip code field. For the address that is in U.S, off course that we have the us zip code such as 60610, 36507, 36037 etc. but we make up the zip code for out of country. for example, if the person live in Poland, we have the address, but in the zip code column, we enter as PO001, or PO002 such. now my question is how can I use the wild card in the query the just pull the address the is out of country such PO001 or PO002. I tried to use like "??*", but it doesn't work. I know the ? is for cahracters. Can anyone have any idea?