Query in access with "*"

[franco]

Hi,
i would like in a query seek elements with "*G", meaning including the "*"
doesn't of course work with like "*G"

who can help me

fdv

 

[Allen Browne]

i would like in a query seek elements with "*G", meaning including the "*"
doesn't of course work with like "*G"

If you want to search for the 2 characters star and G appearing anywhere in
the field, use square brackets around the special character, i.e.:
Like "*[*]G*"

If you just want the records where the field contains the 2 characters star
and G, omit the like, i.e. use criteria of:
"*G"