I’m using Toad as a trial product seeing if we’d like to purchase this software for query use. Currently we use Excel to query the data.
So far I LOVE the interface. it has a lot more bells and whistles than just Excel.
HOWEVER… My problem is that I’m getting a ton of rows back that are blank or with garbage data. I have compared the SQL syntax to that of excel and it’s exactly the same. WHY is this happening. I’m connecting to the DB with ODBC. And the “blank” results vary – sometimes I get like 50 per real item or just 25.
I’m sure I’m missing something simple – Please help!!!
Here is an example of the garbage I’m getting back: