I have a field in my table called Surname. From the front end, I want to search for any surname starting with an 'S'. I don't seem to be able to do this. Entering 'S' or 'S*' does not work.
There is an option in the Search Form area, called 'Default Search Option' Where you can select how you want to search the data. You can also let your users to choose by enabling 'Show Advanced Search Options'
