InfoPath Dev

While using Edit SQL in InfoPath Data Connection wizard.
Can a where clause in the Edit SQL in the data connection wizard in InfoPath takes a value from myFields/my:OfficeTitle?

For example:

select "Title","Office" from "dbo"."Title" as "Title" where Office = <OfficeTittle>


I'm not sure if <OfficeTittle> can be substitute by a parameter field that InfoPath would accept.

No, I'm sorry, but for your SQL Query to use form information, you'll need to add code to modify the query.....

 Would it be possible with XML instead? If yes, what should I look for?

Well, you could add an XML file with all your Offices, and then just filter the data you show in the form, if that is what you mean. What is your desired end result?