hmm, cool. think ill be doing some performance tuning...

thanks again,

kinnon

Hi, great solution, thanks.

yup rbar indeed, but its the only way im aware of to get pagination working with sql server 2000. I do hate cursors, but the data...

ok folks. thanks for your help.

Cool, will bare that in mind. I'm sure it will come in handy.

That works just fine. Thanks very much.

Excellent. You've all been very helpfull.

Journeyman, thats the dogs cahOOnas.

Thanks.

Everyone, you have been brill, and a credit to this site.

My problem is solved, which left me to get on with the task...

Sure thing, OK the first query looks like this while filtering the users by groups ( the group id's are in the @Search_param):

 SELECT

  Recipient.Rcpt_id,

  Recipient.Forename,

  Recipient.Surname,

  Recipient.Delete_ind,

  Security_group.Security_group_desc,

  Site.Site_name

 FROM...

This is great, I'm making progress now. It works when I put the query into a variable first.

However, my problem is a little more complex. I Use embedded CURSOR's...

David,

This is perfect. Thanks very much.

I had a quick look in syscolumns but totally missed the isnullable field.

All the best.