I am using the Active Dashboard and I would like to create a field using a search/convert a field for a word starting with 'A' for example. I know there is EDIT but with this new version of webFocus (8.1.05) I am getting, I hope the library offers a bit more extensive options - something like 'Start With' maybe, hopefully?
Thanks

This message has been edited. Last edited by: FP Mod Chuck,

You can use LIKE and % for wildcard.

WHERE COUNTRY LIKE '%LAND'; will return ENGLAND.