Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can 'A'='a' be true?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00463931
Message ID:
00463941
Vues:
13
>Joe,
>
>You can use the UPPER() function, to convert each variable to upper case as you compare the strings:
>
>
>IF UPPER(var1) == UPPER(var2)
>  Code...
>ENDIF
>
>
>>I would like vfp5 to be case insensitive for certain comparison operations.
>>Is this possible?

Actually I'm more concerned about searching for a string
in a field. My table may have a record of msds.chemical='Acetone'.
My user searches for ACETONE and never finds it in the index.
Is it best to have UPPER() in the index?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform