I noticed that field # '' is faster than empty(field), but it turns out that it was because I had a index on field.
>Sylvain answered your question. I just want to add that
>
>empty(lcAVar)
>
>is faster than
>
>len(allt(lcAVar)) = 0
>
>It is also more clear.
>
>Vlad
>
>>What is wrong with my code??
>>
>>*** Variables:
>>mswhere1 = ''
>>mswhere2 = ''
>>director = "'Brady'"
>>
>>mswhere3 = iif(len(allt(director)) = 0,; mswhere2,iif(allt(len(mswhere2)) = 0, director,;
>> mswhere2 + ' and ' + director))
>>
>>*******
>>I got the error 'Function argument value, type, or count is invalid'
>>
>>Thanks a lot.
--Todd Sherman
-Wake Up! Smell the Coffee!