Check Column Contents (For U Case)

[asingh]

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

[OBP]

I think it is going to take VBA to do it. I am not that good with SQL, so it may be possible using that in the query, but I doubt it.
You can certainly do it with VBA and you can also then manipulate the data if required. i.e. take out the Upper Case or move it to the first character etc.