I'm having a weird problem!
I have a script that does a "Perform Find" on FieldA on all records that have a value over 500
FieldA is a text field
The result I'm getting is:
Showing records where FieldA, has a first character of 6, 7, 8, 9 (regardless of value, even if it is just 64 etc) and 501 - 599
Likewise 3000 won't show up (because the first character is between 0-4)
Is it because it's setup as a text field? and is there a way round this?
or do I have to set up a new field as a number and transfer all the values over?