Alphabet search index...

Results 1 to 2 of 2

Thread: Alphabet search index...

  1. #1
    Join Date
    Dec 1969

    Default Alphabet search index...

    Hello, I have noticed on a couple of sites that they offer their users the ability to search by alphabet letter. For example, if the user clicks on the letter B, it will bring up all articles that start with the letter B. I am trying to perform a similiar task. I guess the easiest way to go about it would be to simply create a field in my Access db table, where I place the letter that I want to search on. <BR><BR>Can anyone offer me another/better way to go about it? Perhaps somehow parse/retrieve only the first letter of my field I am seaching on? Any other ideas on the best way to go about this?<BR><BR>Also, if I write out each letter and make it a hyperlink, will I have to have a seperate SQL statement for each letter? <BR>e.g. <BR>Select * from articles where articleIndex=&#039;a&#039;<BR>Select * from articles where articleIndex=&#039;b&#039;<BR>...<BR><BR>or is there a general SQL statement that I can use for all the letters?<BR><BR>If it matters, I am using C# to develop this site. Is there a particular name for this kind of searching/indexing that I might be able to find tutorials on? <BR><BR>Any information in this area, or answers to some of my questions above would be most appreciated! THank you all!

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Alphabet search index...

    Select * from articles where articleIndex=&#039;" & TheCharYouAreSearchingFor & "&#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