On May 31, 11:15*pm, kidkosmo wrote:
Hi, All,

Is there a way to have Access acknowledge an asterisk as a string
value rather than a wildcard? *I would like to add validation to a
field that will not allow and asterisk to be added as part of that
field; however, the validation appears to recognize that value as a
wildcard and does not allow any value to be entered.

Thoughts, ideas?

Thanks!

Try:

SELECT * FROM MyTable WHERE FieldName LIKE "*[*]*";

to return records from MyTable where FieldName contains an asterisk.
Maybe NOT LIKE "*[*]*" will give the opposite.

James A. Fortune