Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which command is faster in a select sql statement
Message
From
24/04/2003 04:44:12
Liam O'Hagan
O'Hagan Programming Ltd
Ireland
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00780941
Message ID:
00781023
Views:
21
Hi Reygie,

Just a quick warning, LIKEC() is not a case insensitive command in the way that ATC() is. LIKEC() is for use against double-byte character sets. If you intend to search against double-byte language sets use ATCC() instead.

Anyway, to your original question : in my tests, I've found the difference between the two commands to be negligible.

Regards,

Liam




>Im trying to develop an html search program. Anyone who knows which command is faster:
>
>ATC(cSearchExpression, cExpressionSearched [, nOccurrence])
>
>or
>
>LIKEC(cExpression1, cExpression2)
>
>
>Many Thanks
Liam O'Hagan
MCP VFP Desktop Apps
Previous
Reply
Map
View

Click here to load this message in the networking platform