Hey guys, I'm pretty new to SQL and I'm having the following problem.

I am creating a program in VB that looks through Multiple SQL tables for information. I have all the looping done to access all the tables, however, the SQL reader fails whenever I hit a table that doesn't have any information in the column I'm looking up. (These tables are constantly being modified so it may go from having data in the column one day, to the column being cleared the next)

Is there a way to use the reader but instead of throwing exceptions (crashing the program), make the reader skip over tables that don't have anything in the column I'm searching under???

Thanks in advance!!