My database has a number field for users to search for a particular amount. I made it default as less than or equal in the find script.

Set Field[number field, "<=" & number field]

But a user wants to do other find operators, e.g. >=. Is it possible to use Case in the script if a user enters a operator in the field, the default operator will be overidden?

Hi,

make a global field gSymbols to store those operators (Your user may chose that from a list too, if you have attached one to that field)

The script step will became:

Set Field[number field, gSymbols & number field]

raybaudi,

Thank you very much for your input. Another question is that I want my user to select the symbols as phrasal expression, e.g. equal to instead of the equal sign "=" from the list. How do I script this?