main connection using LIKE or BETWEEN

Randy Coates · Oct 18, 2004

How could I have the main connection for an InfoPath form use the LIKE
or BETWEEN keywords or something comparable?

- Randy

Steve van Dongen [MSFT] · Oct 19, 2004

How could I have the main connection for an InfoPath form use the LIKE
or BETWEEN keywords or something comparable?

- Randy

The built-in InfoPath support only handles equality comparisons.
Build the SQL command string as described in MSDN KB 826992.
http://support.microsoft.com/default.aspx?scid=kb;en-us;826992

Regards,
Steve