### 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:

*.*