Query for Percent Sign ('%') in Field

[Smartin]

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?

[Roger]

On Apr 21, 4:59*pm, Smartin <[e-mail]:

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 "*%"

[Smartin]

On Apr 22, 8:01*am, Roger <[e-mail]:

On Apr 21, 4:59*pm, Smartin <[e-mail]:

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 "*%"

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