Listings with SQL

Results 1 to 2 of 2

Thread: Listings with SQL

  1. #1
    Join Date
    Dec 1969

    Default Listings with SQL

    I need to be able to list all records from a table by telling sql i need all the records in "lastname" with the first letter being a, b , c and so on.<BR><BR>Thanx ahead of time!!!!

  2. #2
    Sathiya Guest

    Default RE: Listings with SQL

    Select * from table1 where lastname = "a%" or lastname = "b%" or lastname = "c%" <BR><BR>try and see<BR><BR>

Posting Permissions

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