Select Query Problem/question

[Ravman]

How could I create a "select query" in Access that would find an
employee whose first and last name begin with the same letter?
Fields: Fname, Lname
Table name: employee
Thank you in advance.

[John Baker]

Ravman wrote:

How could I create a "select query" in Access that would find an
employee whose first and last name begin with the same letter?
Fields: Fname, Lname
Table name: employee

SELECT *
FROM employee
WHERE left(fname,1)=left(lname,1);

If the first letters of your names aren't always capitalized you'll have
to correct for that.
--
To Email Me, ROT13 My Shown Email Address

[Salad]

Ravman wrote:

How could I create a "select query" in Access that would find an
employee whose first and last name begin with the same letter?
Fields: Fname, Lname
Table name: employee
Thank you in advance.

Select * from Employee Where Left(FName,1) = Left(LName,1) Order By
Lname,fname