>this is not vfp but i am trying in MS SQL Server
>
>Hope you might have got me
>
>Thanks
>Mohammed

Mohammed,
AFAIK SQL server supports this syntax also :

select * from myTable where lastname in ;
  (select distinct lastname from myTable having cnt(*)>1 group by lastname)

Probably it doesn't support cnt(*). Try count(*) instead.
Cetin