If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Criteria for an email address fied
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: Thanks Chi |
#2
|
|||
|
|||
Criteria for an email address fied
On Thu, 6 May 2010 12:33:00 -0700, 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: Thanks Chi A criterion of LIKE "*#*" should return all record containing a digit. Alternatively LIKE "*[0-9]*" -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Criteria for an email address fied
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: Thanks Chi |
Thread Tools | |
Display Modes | |
|
|