InfoPath Dev

Normally I would do a contains query if just in access, but using InfoPath I am not sure how I can submit a query that operates like contains. I need to be able to find certain words or phrases that might appear in a cell. Any thoughts?

Matt I am currently trying to create a form that will auto populate certain information based on the user entering in a case number. The populated information is pulled from 3 odbc tables that are linked in access. after the information is populated the user will need the ability to type information into more fields. FYI... The information ...

I am a new user... I am currently linking my ODBC tables to Access. In Access I have a query set up to pull specific information (duh). Is it possible (I imagine it is) or can someone explain to me how, to set Infopath to allow a user to put in a number, submit that number to Access, then query an ODBC based on the information given in access, and ...