Asterisk Database Variable

[Jim Jones]

In my tables, the asterisk is an important value of a
variable (it's an examination grade!). How can I get
Access to accept the literal value of * rather than
interpreting it as any number of any characters?

All help appreciated - as ever!

 

[Allen Browne]

Use = for equal, or <> for not equal instead of Like.

If you need to use the Like operator, you can use the literal asterisk in
square brackets, e.g.:
Like "computers use [*] for multiplication"