dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: query to pull records that have first letter A

  1. #1
    Join Date
    Sep 2006
    Location
    Wixom, MI
    Posts
    292

    query to pull records that have first letter A

    quick question

    how would i code a query to select records from a database in the following way

    i want it to pic records that have the field lname with a value whos first letter is A

    so if its value was abbot or allen or armstrong it would get selected

    so i can pull only the names from database that begin with A

    anyone able to help

    thanks

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    select * from table WHERE column like 'A%' or column like 'a%';

  3. #3
    Join Date
    Sep 2006
    Location
    Wixom, MI
    Posts
    292
    great thanks

    i knew it would be something simple

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles