That's entirely possible. I did not notice that the column was varchar. Albert
MDRD wrote:
Albert CREATE INDEX SxTC ON `TravCard` ( `Subjx` ASC ) error this works CREATE INDEX SxTC ON `TravCard` ( `sympt1` ASC ) Subjx is a Varchar, Is Indexing Varchar is allowed??This is my first Varchar column. Marc

