Wildcard not happening for me ... help

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

Hi, I'm trying to query an Access table with a wildcard and get zero
results.

If I use:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters Market YaleTown';

I get back the records as expected, but when I put a wildcard like:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters%';

I get nothing back. Is the '%' not the wildcard character for Access?
Thanks.
 
Dale said:
Hi, I'm trying to query an Access table with a wildcard and get zero
results.

If I use:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters Market YaleTown';

I get back the records as expected, but when I put a wildcard like:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters%';

I get nothing back. Is the '%' not the wildcard character for Access?
Click to expand...

No, use * instead.
 
Thanks Rick ... man, you are quick - I found the answer and deleted my
thread like 2 minutes after I initially posted it.


Rick said:
Hi, I'm trying to query an Access table with a wildcard and get zero
results.

If I use:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters Market YaleTown';

I get back the records as expected, but when I put a wildcard like:

SELECT *
FROM TASKS
WHERE [tasks].[request] like 'Nesters%';

I get nothing back. Is the '%' not the wildcard character for Access?
Click to expand...


No, use * instead.
Click to expand...
 
Back
Top