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