>>Edward,
>>
>>your 1.) the simple string comparsion does not work. That is going back to :
>>
>>ctemp1 = "dr00000v"
>>ctemp2 = "dr00000V"
>>? ctemp1 = ctemp2 -- returns .t. on my computer
>>? ctemp1 == ctemp2 -- returns .f. on my computer
>>
>>It might be interesting to note that in a relation
>>
>>set relation to drawing_id into drawings
>>
>>I get the proper result, no lower case problem.
>>
>>your 2.) I agree with you, this is the SQL out of the Query file I use.
>Don,
>
>I ran your four lines of code on my VFP 5.0 isntall and they both return .F. for me.

Don found it: the cause was the SET COLLATE.

Vlad