Using A2003. I tried to query for records that contain a trailing '%'
symbol in a certain field but was unable to get this to work.

Knowing % is a wildcard character I tried substituting the ASCII code
equivalent, but

SELECT * FROM MyTable WHERE MyField LIKE '*' & CHR(37);

returns all records from the table (most of which do not contain the
'%' symbol).

Is there a work-around?

On Apr 21, 4:59*pm, Smartin <smartin...@gmail.comwrote:

Using A2003. I tried to query for records that contain a trailing '%'
symbol in a certain field but was unable to get this to work.
>
Knowing % is a wildcard character I tried substituting the ASCII code
equivalent, but
>
SELECT * FROM MyTable WHERE MyField LIKE '*' & CHR(37);
>
returns all records from the table (most of which do not contain the
'%' symbol).
>
Is there a work-around?

this works in access97
SELECT r
FROM Table1
WHERE r Like "*%"

On Apr 22, 8:01*am, Roger <lesperan...@natpro.comwrote:

On Apr 21, 4:59*pm, Smartin <smartin...@gmail.comwrote:
>

>

>

>

>

>
this works in access97
SELECT r
FROM Table1
WHERE r Like "*%"

Thanks for the suggestion (FYI it does not work in A2003 -- the query
returns all rows). I ended up using VBA.