The "Or try this" code worked great.

Thanks ALL for the input, much obliged.

here is where my heads at....

select * from syscolumns where id = (select id from sysobjects where name = <tablename&gt

This will provide a list of...

the WHERE .. IS NOT NULL option is my problem.

I don't want to type WHERE col1 IS NOT NULL and col2 IS NOT NULL and col3 IS NOT NULL.......and col100...

i want to remove records where all fields are NULL

I am intending on posting the contents of staging table 1 into final table 1 w/out the NULL rows.

The WHERE clause would have to inspect col1 is null, col2 is null, col3 is null etc...

I could have 100 columns.  This is why i'm trying to you colid 1-whatever...