Title
Perform Find with decimal numbers
Post
Hello FMers,
In a field, I've numbers with decimals (100.1) and just numbers itself all mixed up. is there a way I can search only numbers without decimals?
Thanks
Perform Find with decimal numbers
Hello FMers,
In a field, I've numbers with decimals (100.1) and just numbers itself all mixed up. is there a way I can search only numbers without decimals?
Thanks
Thanks both of you for taking your time to answer my question.
@Phil, I have my field as unique so it gives me the validation error. that is not the case. no criteria is matched. so don't find any records even though I have my data that I know for sure have some records with decimals. do you have any thought on that?
@Ninja thank you. such a brilliant workaround. :)
Perform a find using this as your search criteria in an "omit" request:
*.*