Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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