Create a table with the required mapping, i.e the greek letter and its
precedence.

CREATE TABLE Mappings (
Greek VARCHAR(10) NOT NULL,
Precedence INT NOT NULL PRIMARY KEY) ;

Now, you can use this table in your queries with a join on the Greek column
& then sort the resultset by precedence.

SELECT *
FROM tbl
INNER JOIN Mappings
ON tbl.Greekletter = Mappings.Greek
ORDER BY Mappings.Precedence ;

--
- Anith
( Please reply to newsgroups only )