>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?