You could use a self join.

 select xxx from cursor a join cursor b where a.sss = b.sss and a.field1 != b.field1 

>I need to compare a subset of fields in two records of the same cursor to create output where record1.field not equal record2.field. The best way I can think of is to scatter fields from each rec to separate arrays then do a for ... next loop comparing the values and kicking out field names from a matching array of the ones that are different.
>
>I already know some will always be different so sys(2017) won't help here. I thought there was another function to compare fields but I can't remember or find it. (It's Monday.)
>
>Anyone got a better idea?