CRecordset and ODBC. HELP PLEASE!

Platform: Visual C++ 6.0 w/SP3 running under Windows 95/98.

In ODBC you can pretty much set up you SELECT statement as you do in Oracle! Now what I am looking for is the ability to get the same functionality from the CRecordset m_strFilter as I can from building an Oracle SQL Select statement where clause. Is this possible? Or do I need to transfer the CRecordset data (which is in dbase iv) to an Oracle Database to get this capability?
Any help is as always greatly appreciated!
If you have any suggestions any sample code would be even more appreciated!
THANKS!
Charlie