Thanks laurie. we are using 2005

also is it possible to auto return all columns in the table or we need to explicitly specity all the columns in a select query?

Thanks laurie and dwain.c.

dwain.c i like your approach as it's bit simple but please can you give some explanation so that it makes more sense to me... i always...