Duplicate first five letters

[mystifier]

Struggling with a small query....


I want to return a distinct list of ClientRef abbreviations who have duplicated first five letters.

For example, data:
AAAAA001
AAAAA002
BBBBB001
CCCCC001
CCCCC002

Returns:
AAAAA
CCCCC

My brain's gone to sleep

[June7]

Maybe:

SELECT Left(fieldname,5) FROM tablename WHERE Count(*)>1 GROUP BY Left(fieldname,5);