Are wildcards available when Querying a Database in InfoPath?

[Mary M.]

When querying a database in InfoPath, can one enter a wildcard if only a
portion of the query field is known?

 

[Franck Dauché]

Hi Mary,

You can edit your SQL statement and use any valid syntax:
http://www.techonthenet.com/sql/like.php

Regards,

Franck Dauché