hiya, i have a table in an access database, i need an sql statement that will work in my VB to extract unique codes from it minus the last 2 chars

so here is the database

code...............| blah | blah |
------------------------------------
0654ab
0654cd
1234zz
1234yy
1234zz
023342ab
123ac
123dd

or sumthin like . and this is what i want it to select me

0654,1234,023342,123

any ideas? i've tried this:
SELECT UNIQUE Left(Code,(Len(Code - 2)) FROM Resin
but no luck.

Thanks for your time
Ang