I need to make a simple script to find the records that have a field with a number greater then another number. I.e. (fieldname) > 1000. Or have it omit records that have a specific field empty. I.e. (fieldname) <> "". I can make FM do the FIND and get what I need but can't get the scriptmaker to do the same. I am very frustrated with FM because it is nothing like SQL. SQL is so easy with select statements.

I thought ever db used the "*" as a wildcard. FM doesn't even like that.

Help.

freeze window

Set error capture [on]

Enter Find Mode []

Insert Text [field name,