All, Is there a simple way to find a row in a table where none of columns contain a null value? For example:
SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1; Or do I have to do this manually in my application scanning every column in every row until I find a row with no nulls? Thanks, -Bill