select all null fields?

is there a way to select all fields from a table where the field is not null...something like... select * from myTable where all columns are not null or something to that effect? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net tony@navtrak.net 410.548.2337

to my knowledge,  you will have to do a where cluase for each column SELECT *    FROM myTable WHERE col1 is not NULL       AND col2 is not NULL       AND col3 is not NULL etc.etc. hope that helps! -Josh --- Exciteworks -- expert hosting for less! http://exciteworks.com Tony Weeg wrote: ----- Excess quoted text cut - see Original Post for more -----

yeah, I knew that...kinda wondering if there was a blind way to do it... I have a major join with some views etc, in our new crm system, that im integrating into our backend ... so what my thinking was, rather than weed through all the columns, I could get the ones that arent null...those would be the ones I cared about :) make sense? so, I guess not... later. to my knowledge,  you will have to do a where cluase for each column SELECT *    FROM myTable WHERE col1 is not NULL       AND col2 is not NULL       AND col3 is not NULL etc.etc. hope that helps! -Josh --- Exciteworks -- expert hosting for less! http://exciteworks.com Tony Weeg wrote: ----- Excess quoted text cut - see Original Post for more -----

you could always loop through the columnlist and generate the query dynamically. -Josh Tony Weeg wrote: ----- Excess quoted text cut - see Original Post for more -----