>Thanks... This is a dialog where users pick from fields to specify order, so I never thought of indexes here, sorta 'duh' feeling! INDEX ON is ASCENDING by default, so ORDER BY DESC gives the opposite order to ORDER BY , right...

Dick,

Hey, been there, done that 'duh' thing myself. *G* It's kind of like getting a scout badge. *BG*

Best,

Best,


DD

A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.