Search for repetition

[azhar2006]

Hello guys
I have a query that searches for repeaters, and used this expression.

In (SELECT [Field1] FROM [tblGnr] As Tmp GROUP BY [Field1] HAVING Count(*)>1 )

And I've succeeded.
But what I want to find the first 10 characters of the sentence.


How is that
Thanks in advance.

[orange]

Use this query

SELECT tblGnr.ID, tblGnr.Field1
FROM tblGnr
WHERE Left([field1],10)
 In (SELECT Left([field1],10)  
 FROM [tblGnr] As Tmp GROUP BY [field1] HAVING Count(*)>1);

Good luck

[azhar2006]

Thank you very much orange
Wonderful