Hi...after some further investigation if I remove the following from the script then I can retrieve the correct number of records - can you see anything that is wrong with...

I've enclosed the complete script (Cursor)....

declare

@Sysid integer,

@net_user varchar(24),

@user_sysid int,

@cv_user varchar(12),

@CV_docnum int,

@dm_docnum int,

@datetime datetime,

@cv_action varchar(24),

@activity int,

@cvuser_sysid int,

@activity_desc varchar(70)

Declare activity cursor for

select *, case Action

when 'Edit' then 2

when 'Updated' then 20

when...

Thank you for your reply - I'm trying to do the following:

Update dbo.table

set c_alias = 'Test'

where c_alias = 'Work', 'Book', 'Event' etc

Regards