Hi all,

I am trying to use the find function in Filemaker Pro to find a range of numbers, but I only care about the last 4 digits of the 7 digit numbers I am dealing with. So, the first 3 digits of the 7 digit numbers I want to find do not matter. I tried searching in my intended field using "###4120..###4260" for example, but the find request did not work. I see that you can search ranges with ".." or "..." but it seems like my "#" symbols are messing this up somehow. Does anyone have any suggestions?

Thank you!

Michael

Basically yes. If your NumberField contains "403123321" then the stored calculation _cnNumberField = right(NumberField;4) would return "3321". Set field to return data of type "number" and the storage for the calculation to be "Indexing = All" and then do your search on that field. eg. "3321...3467".

Stephen

btw "_cn" tells me that the field is calculated and returns data of type number. "_ct" would tell me the field is calculated and the data type is text.