Search for Latin Name starting with A in a field

Discussion created by rolfwoodies on Aug 16, 2013
Latest reply on Aug 16, 2013 by flybynight



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