Is there a way to query SAP using the QvSAPSQLConnector with a WHERE field LIKE '*' type of clause ?
You can use LIKE statement in SELECT queries. But instead of "*", "%" is used as wildcard, like this:
SELECT field FROM table WHERE field LIKE 'prefix%';
Works perfectly thank you very much Tomas.
You can read about OPEN SQL syntax here :
Retrieving data ...