How to check for lower case letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top