>It might be. If myfld is zero yet zero is not in myarray then the result is zero returning zero records. OTOH, if myfld is not zero but myarray contains zero and also contains myfld (which is non-zero) then the result set is not empty (zero records). If myfld is zero and zero is an element of myarray then scanning for zero where there is a zero is not zero and NOT zero records will result.
>
>I hope that I have cleared this up.
>
>>>>My code is:
>>>>select * from mytable where ascan(myarray,myfld) # 0 into cursor mycursor...
>>>>What does # 0 mean or do ????
>>>
>>>#0 means 'not equals' zero. Same as != 0 or <> 0.
>>----
>>Hi Rick,
>>Is the select statement saying...where myfld is not equal to 0?
--
Hi John,
it clears things up, thanks ..:))