M momoko Registered User. Local time Today, 14:47 Joined Oct 7, 2001 Messages 41 Nov 8, 2002 #1 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.
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.
A antomack Registered User. Local time Today, 14:47 Joined Jan 31, 2002 Messages 215 Nov 8, 2002 #2 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.
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.
