funkykayli
Board Regular
- Joined
- Apr 25, 2007
- Messages
- 183
I have a query in which I want to find duplicates. I can not use the duplicate query because:
I have a list of claim numbers. Here is an example of duplicates I need to identify:
12345A
12345B
12345C
So the duplicate query won't work because they are actually different. Is there a way to look at just the first 5 characters for duplicates?
I have a list of claim numbers. Here is an example of duplicates I need to identify:
12345A
12345B
12345C
So the duplicate query won't work because they are actually different. Is there a way to look at just the first 5 characters for duplicates?