>>>If you want to add this to the select, then
>>>
>>>select Name, cast(0 as I) as IDField from myTable group by Name having count(*) > 1 into cursor csrDups readwrite
>>>
>>>replace all IDField with recno() in csrDups
>>
>>
>>im Tryin that (the 1st line) but im not too sure the query is liking that cast
>
>Do you get an error?
yea i did synax error nothing two big
Select fname,Cast(0 as 1) as clientid from otest;
group by fname having count (*)>1;
into cursor csrdups readwrite