ANSI 92 Digit Wildcard (# alternative)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a digit wildcard in ANSI 92?

I need an alternative to "*#*"

I tried "%[0-9]%" with no luck...
 
Did you use double quotes (as you posted) or single quotes?

LIKE '%[0-9]%'



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I used double quotes, but single did not work either

Here is the query, and I am using microsoft query to pull data from a MySQL
server. It is for a report that has to be in excel, and I am only familiar
wit access.

SELECT cdileads_0.month, cdileads_0.sch, Count(cdileads_0.id)
FROM leadresponse.cdileads cdileads_0
WHERE ((cdileads_0.adkey) Like "IN%" And (cdileads_0.adkey) Not Like
'%[0-9]%') OR ((cdileads_0.adkey) Like "INM%")
GROUP BY cdileads_0.month, cdileads_0.sch
HAVING (cdileads_0.month>(current_date-60))

John Spencer said:
Did you use double quotes (as you posted) or single quotes?

LIKE '%[0-9]%'



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

BOONER said:
Is there a digit wildcard in ANSI 92?

I need an alternative to "*#*"

I tried "%[0-9]%" with no luck...
Click to expand...
Click to expand...
 
At this point I am stuck. But then I've never tried to pull data from MySQL
into Excel.

Perhaps someone else has an idea.

Anyone care to step in?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

BOONER said:
I used double quotes, but single did not work either

Here is the query, and I am using microsoft query to pull data from a
MySQL
server. It is for a report that has to be in excel, and I am only
familiar
wit access.

SELECT cdileads_0.month, cdileads_0.sch, Count(cdileads_0.id)
FROM leadresponse.cdileads cdileads_0
WHERE ((cdileads_0.adkey) Like "IN%" And (cdileads_0.adkey) Not Like
'%[0-9]%') OR ((cdileads_0.adkey) Like "INM%")
GROUP BY cdileads_0.month, cdileads_0.sch
HAVING (cdileads_0.month>(current_date-60))

John Spencer said:
Did you use double quotes (as you posted) or single quotes?

LIKE '%[0-9]%'



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

BOONER said:
Is there a digit wildcard in ANSI 92?

I need an alternative to "*#*"

I tried "%[0-9]%" with no luck...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top