Hi,

Suppose I have a tbl in access "tbl_CheckStatus", and I have column in this table... "Eval". All the values in column "Eval" are of string type. I want to run a check that will tell me in the corresponding column, if any value in "Eval" has a upper case letter in it. The Upper Case letter could be at the end, beginning, or embedded within the string. [Example: Hello, hellO, heLLo].

Is it possible to do this at the query level, using formula's [build]. I don't want to get in back - end VBA..? The output for the check should just be YES = 'means there is a U case', or NO = 'means there are no U case'.

thanks for the help.

regards,

asingh