Ms Access Help Please?

- What is the difference between '#' and '?' when they


are used with the LIKE operator?





-- Explain what the following LIKE patterns would match:


a) "a*"


b) "[!ab]ff#"


c) "assg[1-4]*"


d) "CS????"

Ms Access Help Please?
a) any record beginning with 'a'


b) the record can't begin with a or b as the first character, must be followed with ff and have one digit.


c) record starts with assg, followed by 1, 2, 3, or 4, and then any number of any character


d) CS followed by 4 characters.