oh srry yea spelling it out works
but i use my otest table an also the table with the number of times a name appears
example

2 peter

showing you how many times the name appears and the cursor puts the name out in a list but it gives all of them 0 but i cant blame it, we didnt increment did we?

it shows

0 peter
0 peter

>
>:))
>
>1 is not 1. It is supposed to be I or may be you can spell it out - Integer.
>
>E.g.
>
>select fName, cast(0 as Integer) as ClientID from oTest group by fName having count(*) > 1 ....