Prev: Access 2007 Will not accept wildcard
Next: Sort Order of Update Query
From: Chi on 6 May 2010 15:33
Sorry, I posted my email at the Report session..

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:

Chotran2(a)carle.com
Knguyen2(a)clinic.com
Sue2nguyen(a)parkland.com


Thanks
Chi

From: John W. Vinson on 6 May 2010 15:44
On Thu, 6 May 2010 12:33:00 -0700, Chi <Chi(a)discussions.microsoft.com> wrote:

>Sorry, I posted my email at the Report session..
>
>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:
>
> Chotran2(a)carle.com
> Knguyen2(a)clinic.com
> Sue2nguyen(a)parkland.com
>
>
>Thanks
>Chi

A criterion of

LIKE "*#*"

should return all record containing a digit. Alternatively

LIKE "*[0-9]*"

--

John W. Vinson [MVP]
From: John Spencer on 6 May 2010 15:44
Answered there.

Like "*[0-9]*"

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Chi wrote:
> Sorry, I posted my email at the Report session..
>
> 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:
>
> Chotran2(a)carle.com
> Knguyen2(a)clinic.com
> Sue2nguyen(a)parkland.com
>
>
> Thanks
> Chi
>
 | 
Pages: 1
Prev: Access 2007 Will not accept wildcard
Next: Sort Order of Update Query