Something else you could try is inserting the select statement into a temporary table, and then selecting on this for your cursor query. Tom __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com