string contains * - Help!

[doodle]

windows xp,access 97



how can i check to see if a string contains an astericks?

example:

513703*4526

i can't use: Not Like "*"



thanks,

-doodle

 

[John Vinson]

windows xp,access 97



how can i check to see if a string contains an astericks?

example:

513703*4526

i can't use: Not Like "*"

You need to use brackets to make it take the wildcard literally:

NOT LIKE "*[*]*"

will find all the records which do not contain an asterisk anywhere
within the field.

John W. Vinson[MVP]