6 Replies Latest reply on Aug 16, 2013 2:38 PM by flybynight

    Search for Latin Name starting with A in a field

    rolfwoodies

      Hi,

       

      Having problems performing a search that just bring back the fields that contain words starting with A.

       

      The field I am searching has Latin names of plants entered. I would like to be able to search just for the A's, but when I do a search for A, it is obviously searching for A in the whole word, rather than just the first letter. Also latin plant names are not always just one word, so I would like it to bring back just the first words with A.

       

      I can sort A-Z fine, but then would like to omit B-Z from viewing.

       

      I then would like to be able to serach for B's in the same way, omitting A & C-Z from viewing.

       

      Anyones help would be much appreciated as I just cannot figure this one out.

       

      Many thanks