>>Tommy, never tested, never used (I even don't want to post this), but I am curious if this could works (so you are my experimental rabbit :o))))))
>>
>>*** SET all relations between tables
>>SELECT YourMainTable
>>INDEX ON UPPER(Drugs.DRUG_NAME) TO TemIDX
>>
>>Then use that index to chnage orders. As I said, not tested at all and I don't know which problems this could cause.
>
>I will give it a try. Hopefully, no unseen complications from this.
>
>Thanks!
>
>Tommy
I would not even try... I would use any other alternative approach suggested...
If it's not broken, fix it until it is.
My Blog