If it is a text field try this --
Like "*[0-9]*"

--
Build a little, test a little.


"Chi" wrote:

Hi,

I would like to make a query that give me a list of the emails address with
number in it?

I tried to use wildcard characters in the query design view, but it always
gives me a blank record.
Ex: I would like pull out the emails like below:






Thanks
Chi