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

    Search for Latin Name starting with A in a field




      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