Ken: Thanks for your input. I think I'm regaining my sanity now. Thanks for your help. CWH.
>mProduct = "" is Always True when
SET EXACT is OFF. Not so when EXACT is ON. Of course empty() is the best solution here.
>
>>Chcuk,
>>
>>Forget my lastr eply. The problem is as Keith pointed out.
>>
>>mProduct = "" is
Always True>>
>>That is how strings are compared in xBase. The strings are comapred one character at a time until the striong on the right is exhausted. Your string on the right has a length of 0 so it is equal to anything on the left.
>>
>>Fix this by using the EMPTY() function instead.
>>
>>IF EMPTY(mProduct)
>>...
Chuck Henry