Query in access with "*"

  • Thread starter Thread starter franco
  • Start date Start date
F

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
 
franco said:
i would like in a query seek elements with "*G", meaning including the "*"
doesn't of course work with like "*G"
Click to expand...

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"
 
Back
Top