SQL Query

Results 1 to 2 of 2

Thread: SQL Query

  1. #1
    Join Date
    Dec 1969

    Default SQL Query

    I have an access database and a table called tCustomers. In that table I have fields for FirstName, LastName, etc. What I&#039;m trying to do is to make a query that only brings up those customer&#039;s whose last name starts with a certain letter for example "A". I tried the following using the LIKE method but that brings up all the customers that has a letter a in the last name.. I only want to bring up the customer&#039;s whose last name STARTS by A.<BR><BR>Thanks in advance<BR><BR>Carlos

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Query

    SELECT * FROM tCustomers WHERE LastName LIKE &#039;L%&#039;

Posting Permissions

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