I am not aware that the period is a wildcard character in Access. Since you
aren't using any wildcards in the string, I don't understand why you are using
the like operator instead of the equals operator.
If the period is a wildcard then you would enclose it in brackets as. Brackets
[] are special characters and as such must be bracketed.
'access[.]'
Are you doing this with Access + Jet (.mdb) or with an Access Project (.adp).
The wildcards are different between the two. Or are you trying to do this with
some other product (MS SQL, MySQL,???)?
In Access + Jet (.mdb) database then
[Name] like '\[access\].'
equates to match name if it
starts with \
has a 2nd character of a c e or s
and is followed by a period.
I am trying to write a query where the select's where clause is "WHERE [Name]
like 'access.' or [Name] like '\[access\].'" but it does not work. If i
remove the '.' it works fine, but i need look for records that include that
period.
thanks for any help
ben