Sorting by the first 2 digits

[Ivains]

Hi Everyone,
Can anyone tell me how I can sort using the first 2 digits? I am trying to sort a database, the vehicle plate starts off like 94-10818, 00-707, and so on. What I want it to do is sort the first 2 digits so I can see the older vehicles first.

Here is my sql statement:

$sql = "
SELECT *
FROM lsv
WHERE lsv.org = \"$org\"
ORDER BY lsv.reg DESC
";

Any help would be appreciated.

Thanks
:o) Ivan

[sarahk]

consider:

$sql = " 
SELECT reg, left(reg,2) as sortorder
FROM lsv 
WHERE lsv.org = \"$org\" 
ORDER BY sortorder DESC 
";