>Hi,
>
>Add next row to your code:
>

>SET COLLATE TO "MACHINE"
>

>
>For other collates can be "GALA"= "Gala"
>
>MartinaJ
>
>>*Cursor with unique list of string
>>CREATE CURSOR c_UniqueString (cStr C(50))
>>
>>*Cursor where we want to find all unique string from.
>>CREATE CURSOR c_Data (cCode C(40), cdesc C(50))
>>
>>INSERT INTO c_data (ccode, cDesc) VALUES ("ARIA", "Ariane")
>>INSERT INTO c_data (ccode, cDesc) VALUES ("GALA", "Gala")
>>
>>SET EXACT ON
>>SET ANSI ON
>>
>>*First column
>>SELECT DISTINCT CAST(RTRIM(cCode) AS V(40)) as string FROM c_data WHERE !ISNULL(cCode) INTO CURSOR c_DistinctCode
>>
>>INSERT INTO c_UniqueString (cStr) SELECT string FROM c_DistinctCode WHERE string NOT IN (SELECT cStr FROM c_UniqueString)
>>
>>*Second column
>>SELECT DISTINCT CAST(RTRIM(cdesc) AS V(40)) as string FROM c_data WHERE !ISNULL(cdesc) INTO CURSOR c_DistinctDesc
>>
>>INSERT INTO c_UniqueString (cStr) SELECT string FROM c_DistinctDesc WHERE string NOT IN (SELECT cStr FROM c_UniqueString)
>>
>>*We should have 4 values in c_UniqueString, but we are missing Gala in lower case. The NOT IN does not take into account Lowercase and UpperCase.
>>
>>Any work around ?

Right on Martina!

By default our SET COLLATE TO is set to General because of the French language in our Province.
It just byte us with some SQL queries.

Thanks a lot for this finding.
Like Lutz mentioned, it's kind of a fine print.