Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to index
Message
From
05/04/2000 18:50:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355970
Message ID:
00355974
Views:
18
Whoops, forgot. Using Upper is a good rule of thumb. Even if you don't captialize the company name during data entry, If the index is on Upper(compname), you can find all the "ABC COMPANY".

pf

>Is there a rule of thumb to follow when using index expressions? Is it common to index on something like Upper(AllTrim(FieldName))? Are there performance issues in doing this?
>Any thoughts?
>TIA

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform