Filter records (1 Viewer)

[momoko]

Hi,
I have a field which contain for e.g 123445A, 125344B, 933456

How can I filter out those that with an ending that contains character? Character range from A-Z.

Thanks.

 

[antomack]

Assuming that it is only the last character that may be non numeric then you could use the following in a query

IsNumeric(Right([YourField],1))

Set criteria as True to get records where last character is numeric, false to get those where last character is a string.