azhar2006
Registered User.
- Local time
- Today, 15:35
- Joined
- Feb 8, 2012
- Messages
- 202
Hello guys
I have a query that searches for duplicate names and uses this expression. But this expression finds the repeater and matches 100%. ..what I want is for the expression to count only the first 10 characters of the name. how can I do that .
I have a query that searches for duplicate names and uses this expression. But this expression finds the repeater and matches 100%. ..what I want is for the expression to count only the first 10 characters of the name. how can I do that .
Code:
In (SELECT [F] FROM [tbl] As Tmp GROUP BY [F] HAVING Count(*)>1 )