InfoPath Dev

Thanks, but I dont know SQL.  Now I'm totally lost.   One problem I'm having right now is when I use the "Run Query" button it returns all records in the database.  I'd like to be able to narrow down the results based off a partial name match.  And then I would like to be able to choose that one record.

I'm fairly new to IP, but I'm fumbling along.  I now have a question. An example of the 2 records I am trying to get from the db: Joe Smith 123 Main Street Anytown, USA and Joe Smith 789 Main Street Anytown, USA what I am trying to do is query the db to display only these two records to display when I type in a portion of ...

Thanks, but this doesnt work in IP 2003 only IP 2007

I think I'm on the right path, but I'm still stuck and hope someone can help out.  I have found that the following forumula will translate the first letter of the first word to an upper case. concat(substring(translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1, 1), substring(., 2, ...

I would like to create a drop down menu that would use the function today() and add 7 days.  Where the ouput would be displayed as a date.  How can I do this using InfoPath 2003? TIA

I'm using InfoPath2003 How would I go about correcting an address to use upper case letters?  ie correct 123 main street to 123 Main Street TIA