Hi Bob,
>PS. Unfortunately, I have some tags that have a character field + a DTOS(mdate) function
You don't need to upgrade index tags to MySql for the purpose of sorting data. That's something you do with the ORDER BY clause of your SQL query or by indexing the result set in VFP. SQL servers need indexes to ensure unqiue constraints and for optimizing queries.
--
Christof