>Why do you use "INDEX ON BINTOC(iOrder)"? Is there a difference (excepted space) to INDEX ON iOrder)
>
>Agnes
I would index directly on the field, and use bintoc() (to save space, as compared with str()) when indexing on more than one field.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)