Extracting Records that end in 999

Hi Aveen,

I would turn the field into a character field and then use the @right function to do the extract.  Here is an example:

@right(@Str(FIELD, 10, 2), 6) = "999.00" .OR. @right(@Str(FIELD, 10, 2), 2) = "99"

It assumes that the field has two decimal place.

Hi Aveen, 
you could try the following at least for 999: @abs(@int(FIELD))%1000=999
Sadly it works only for searching amounts without looking at the decimal place. 
 
For example:
@abs(@int(1299.88))%100 returns 99.00
@abs(@int(1299.88))%1000 returns 299.00
@abs(@int(1299.88))%1000 returns 1299.00