Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which command is faster in a select sql statement
Message
De
24/04/2003 04:44:12
Liam O'Hagan
O'Hagan Programming Ltd
Irlande
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00780941
Message ID:
00781023
Vues:
20
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform