Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Google-like queries in FoxPro apps
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00624182
Message ID:
00624318
Views:
17
David,
I'm using it based on what others have seen. Check out:
http://www.west-wind.com/wwthreads/ShowMsg.wwt?MsgId=03P0U53DC
and for a test that was done with VFP 6:
http://www.west-wind.com/wwthreads/ShowMsg.wwt?MsgId=03S0INFBF
VFP 7 may have made it more consistent...

>Claude,
>
>I can't imagine that spending the time to UPPER() megabytes worth of memos and then to use ATC() on top of that would be faster than just using atc() alone. I don't really have an adequate test table to try these tests:
>
>atc( "searchphrase", memofield )
>atc( "SEARCHPHRASE", memofield )
>atc( "searchphrase", lower( memofield ) )
>atc( "SEARCHPHRASE", upper( memofield ) )
>at( "searchphrase", lower( memofield ) )
>at( "SEARCHPHRASE", upper( memofield ) )
>"searchphrase" $ lower( memofield )
>"SEARCHPHRASE" $ upper( memofield )
>
>>For some reason UPPER makes it speedier unless something has changed in VFP 7
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform