List on partial input

Questions and Help
1

How can I adapt this snippet to list from partial input e.g inputting OL will list all the postcodes beginning with OL

Postcode: {formtext: name=search}
{dbselect: SELECT FullName, PostCode, Region FROM AddressBook WHERE PostCode LIKE (UPPER (@search)); space=7izj0Hpo8D9JLSzgo2YogI; multiple=yes; menu=no; name=person}

fullname postcode region
{repeat: for row in person}{=row.fullname} {=row.postcode} {=row.region}{endrepeat}

2

Forget that, I worked out that using OL% does it

3

Hi @tonydow ,
You can have a text field and make a search on your own. Something like this.

{formtext: name=search}{if: search<>""}
{dbselect: SELECT FullName, PostCode, Region FROM AddressBook where contains(lower(FullName), lower(@search)); space=id; name=person; multiple=yes}
{endif}

Full name Post code Region
{repeat: for row in person}{=row.fullname} {=row.postcode} {=row.region}{endrepeat}
4

Thanks. I changed the select to use (@search&"%") and that seems to work