Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster way to search for a word
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01322854
Message ID:
01322873
Views:
13
It looks like you are looking for 'HARDDISK' at the start of the field ( AT()=1 )
The best way would be to have an index on the UPPER(stockname)

Then

Browse for upper(stockname)='HARDDISK'

OR

Browse Key 'HARDDISK' (After Index is set)

OR

SELECT * FROM TableName WHERE UPPER(stockname)='HARDDISK'

Without testing I would guess the second is fastest

Bob



>what's the fastest way to search for a word?
>
>I use:
>
>SET FILTER TO AT(UPPER('HARDDISK'),UPPER(stockname))=1
>BROWSE
>
>but I think it's too slow
>
>thanks for the help
>
>Jerry
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'
Previous
Reply
Map
View

Click here to load this message in the networking platform