• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Making a qery to search for words that start with the letter A

How would I make a query to return only those records that start with the letter A?
0
daisypetals313
Asked:
daisypetals313
  • 2
1 Solution
 
Gregory MillerGeneral ManagerCommented:
SELECT tblUserNames.Username FROM tblUserNames WHERE ((Left([Username],1)="M"));

Quick and dirty to find all usernames that start with "m"
0
 
Rey Obrero (Capricorn1)Commented:
another way is

select * from
TableX
where [Fieldname] like "m*"
0
 
daisypetals313Author Commented:
Thanks.
0
 
Gregory MillerGeneral ManagerCommented:
ouch
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now