In general you should avoid using Select *, instead you should list all the fields you really need. And to use the Distinct keyword, you will as good as always need to list the fields anyway.

>Oh..well..prior to posting i was playing around with select Distinct. if i did select distinct mytable.name it would work fine. but if i did select distinct * from mytable it would tell me " Operation is invalid memo, blog,general or picture file, and when I clicked on help for the error is says an index command cannnot specify a memo or blob key expression and something else about unions
>>
>>DISTINCT has nothing to do with indexes (other than using them to speed up the selection process). It reduces the record set so that there are no duplicate records for the entire field list.