doing this for a DoD project, everything is capitalized. I am actually writing the sql statement to the debug window using the debug.print command, and pasting it into the SQL Plus editor and getting 4 rows there, while 0 records in VB...