> You could add 26 SMALLINT columns to your table, > each with its own index. jason, good idea, i like the creativity sadly, mysql can use only one index for each table in a query ;o) ------------- rudy http://r937.com/ | http://rudy.ca/ buy my book "Simply SQL" from Amazon -- http://www.amazon.com/exec/obidos/ASIN/0980455251/