Select-options wrong range

[Former Member]

I build a select-option for a selection from a table.

If I give a range like 1 to 3 the selection returns all the values from 1 to 3 including all other values starting with 1 or 2. How can I prevent that?

[matt]

You've defined your select option as a character type. If you choose A to B, you'll get AA, A3, A5, AZ and B. So, if you choose 1 to 3, you'll get 11, 13, 15, 1Z and 3.

You must define your selection option as a numeric or NUMC.

matt

[Former Member]

The problem is it is alphanumeric field it can also contain a range from A to C.