Alpha Query

[zyus]

Records in my Emp fields is as follows

Emp
01-2-06ABC
1-1-09CDA
01/04/09BVE

In my query, i want to select alpha and i can get

Emp1
ABC
CDA
BVE

Thanks

 

[KARL DEWEY]

Try this --
SELECT zyus.Emp
FROM zyus
WHERE (((zyus.Emp) Not Like "*[0-9]*"));