SQL Question

Results 1 to 3 of 3

Thread: SQL Question

  1. #1
    Join Date
    Dec 1969

    Default SQL Question

    Is there a way to use SQL to select only records which begin with a certain letter of the alphabet?<BR><BR>One of my field names is "Name" and I would like to select only names that begin with the letter A, B, C, etc.<BR> <BR>SELECT * FROM Table WHERE .......???

  2. #2
    Garth Guest

    Default RE: SQL Question

    ...WHERE SUBSTRING([Name],1,1) = &#039A&#039<BR><BR>Garth<BR>www.SQLBook.com<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: SQL Question

    Or:<BR><BR>... WHERE name LIKE &#039A%&#039<BR><BR>which may be more efficient, since the isn&#039t a function call involved.<BR><BR>Dunc

Posting Permissions

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