UNIX for Dummies Questions & Answers

I'm trying to connect to a DB on a windows server from a DB on a unix server. While I can connect, I can't seem to get the expected results back, I'm only getting the number "2" back no matter what date I put in (I should be getting "408" or "410" depending on the date). Funny, when I go into Q-engine and run the statement I *do* get back the results I expect. Here is what I'm trying (by the way, I *am* switching the user to the UNIX DB owner first) and how the result looks:

sqlplus /

connect windowsDBUSER/windowsDBPASS@windowsDBNAME
Connected

SQL> select count(*) from tablename where transdate='22-Jul-2007'
2

Thanks for any help you can offer!

What if you try this:

SQL> select * from tablename where transdate='22-Jul-2007'

What records do you get back? Maybe this will help you trace the problem.