AnsweredAssumed Answered

Greater than (>) Problem

Question asked by MarkBanin on Feb 20, 2018
Latest reply on Feb 21, 2018 by philmodjunk

Hi all

 

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?

 

Thanks

Outcomes