>>Dear Experts
>>
>>Field1 of Table1 has following data
>>
>>Boris
>>Cetin
>>Jeferson
>>Cetin
>>Tony
>>Boris
>>Validimir
>>Boris
>>
>>Questin # 1
>>I want to extract all unique matching records as
>>Boris
>>Cetin
>
>
>select distinct FirstName from Table1
>
>* or:
>
>select FirstName from Table1;
> group by FirstName
>
>
>>Questin # 2
>>I want to extract not unique but all matching records as
>>Boris
>>Boris
>>Boris
>>Cetin
>>Cetin
>
>
>select FirstName from Table1;
> order by FirstName
>
>
>Is this what you need? I hope I understood your question correctly.
Second one looks like
select * from table1 where Firstname inlist("Boris","Cetin","Hilmar")