Skip to Content
0
Former Member
Nov 30, 2006 at 08:24 PM

Searching for particular characters in an alphanumeric field

46 Views

Hi All,

I want to check if the last three characters of a field in a record have particular digits. eg. I have a field in a record which has a value AAABBBCCCXXX. Using the last three characters XXX, I need to find all the records which have XXX as the last three digits of the field in the table. Which would be the best way to do this?

Thanks,

AP