>>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")