I think the 2005 option may be my best choice or dynamic sql as Sergey suggested. Actually my select statement is a compound union from the same underlying table - quite "messy"

Thanks

Glenn

>Correction on my last post....it's actually SET ROWCOUNT....you can set it, and then set it back after you finish your query....again, check books online for actual usage.
>
>Kevin