Query Lacking

[rommel_alix]

hi gurus,

hi i already did the MYISAMCHK on my corrupted tables,, i dont get error 1030 anymore, but im still wondering why is it whenever i request a query,, it does'nt give me the complete results..

this is the situation:
select acctname from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me 40000 records

select heading from <<tablename>> where acctname like 'A%' limit 40000;
---- this query gives me only 1664 records

-- why is this happening? i have an index on field <<acctname>>, does it affect this? or this is happening bcoz of different reasons..

thanx very much