I have a file which contains the First Name, Middle Name or Initial, and Last
Name, I would like to know how to check the first character to see if it is
in the Upper Case. If the first Character of the name is not in the Upper
Case the records will be selected by using a Select Query in Access.
--
H Yuille

Compare the ASCII values of the character converted to upper case with the
actual character, e.g.

SELECT *
FROM YourTable
WHERE
ASC(UCASE(LEFT([Last Name],1)))
<> ASC(LEFT([Last Name],1));

Ken Sheridan
Stafford, England

"H Yuille" wrote:

> I have a file which contains the First Name, Middle Name or Initial, and Last
> Name, I would like to know how to check the first character to see if it is
> in the Upper Case. If the first Character of the name is not in the Upper
> Case the records will be selected by using a Select Query in Access.
> --
> H Yuille