Filter by 'not' statement

[Randygk]

I have item id's with numeric values and item id' with alphanumeric values:

ie... inv_mast.item_id
10111
10138M
NIM2015
asst10
9185
99.01895
out of the previous records I would only want to show inv_mast.item_id records 10111 and 9185. How can I filter out all other records?

Thanks in advance,
Randy

 

[lbass]

It looks like you want only numeric values which are whole numbers. If this is the case, then something like this should work as a filter:

isnumeric({table.itemID}) and
remainder(val({table.itemID}),int(val({table.itemID}))) = 0

-LB

 

[Randygk]

That worked GREAT!! Thanks!!