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
..

"BOONER" <BOONER@discussions.microsoft.com> wrote in message 
news:857CC9F5-28B8-4E98-BF89-7EC518F4349F@microsoft.com...
> Is there a digit wildcard in ANSI 92?
>
> I need an alternative to "*#*"
>
> I tried "%[0-9]%" with no luck... 

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" wrote:

> 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" <BOONER@discussions.microsoft.com> wrote in message 
> news:857CC9F5-28B8-4E98-BF89-7EC518F4349F@microsoft.com...
> > Is there a digit wildcard in ANSI 92?
> >
> > I need an alternative to "*#*"
> >
> > I tried "%[0-9]%" with no luck... 
> 
> 
> 

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" <BOONER@discussions.microsoft.com> wrote in message 
news:E683F8D2-011A-40E8-B787-706D443E3809@microsoft.com...
>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" wrote:
>
>> 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" <BOONER@discussions.microsoft.com> wrote in message
>> news:857CC9F5-28B8-4E98-BF89-7EC518F4349F@microsoft.com...
>> > Is there a digit wildcard in ANSI 92?
>> >
>> > I need an alternative to "*#*"
>> >
>> > I tried "%[0-9]%" with no luck...
>>
>>
>>