>>I have a table called ii, with an index call cref (where cref is a 4 character field). It I issue the command
>>
>>llFound = SEEK(lcref,'ii')
>>
>>I get the following results
>>

>>lcref  llFound   Comment
>>0303    .T.      as expect field cref has these values
>>0403    .T.      expected .F. since there is no data for cref = 0403
>>                 confirmed this by using Select * from ii when ii.cref = lcref
>>                 and get no records
>>0503    .F.      as expected since there is no data
>>

>>What am I missing, why is llFound true for lcref = 0403
>
>Claude,
>Might it be you're unintentionally changing tag in between or when you execute this there is a cursor\table in current workarea with a fieldname 'lcref'.
>

>lcRef='0403'
>? SEEK(lcref,'ii','tagnamesuggested'), SEEK('0403','ii','tagnamesuggested')
>if SEEK(lcref,'ii','tagnamesuggested')
> select ii
> browse
>endif
>

Cetin

I get .t., .t. and end end up on last line of table with exact set to on or off. Value of cref is 0303. There is another date field which is 04/01/2003.

My temp (I hope) work around is

CALCULATE cnt() FOR cref = lcref TO lncrefcnt IN ii
llFound = IIF(lncrefcnt > 0,.T.,.F.)