[RESOLVED] Select distinct Based only on the first 2 chars?

[skip]

Hello,,

Is it possible to select distinct on the first 2 charectors of a field? i.e

A_FIELD

Frog
Frame
Ball
Balloon
Bat
Car


And return only

Fr, Ba, Ca

////////// SOLVED

$row_q = mysql_query("SELECT DISTINCT (LEFT(A_Field,2)) as pco from pcode");
while($row = mysql_fetch_assoc($row_q)){
echo $row['pco'];
echo "<br />";
}