SAP SQL Connector Like clause

[#1]

Hi guys,

Is there a way to query SAP using the QvSAPSQLConnector with a WHERE field LIKE '*' type of clause ?

Thanks!

[trm · Accepted solution]

Hi Ricardo,

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%';

Regards,

// Thomas

[mats_olin]

You can read about OPEN SQL syntax here :

http://scn.sap.com/community/abap/blog/2014/05/21/a-complete-guide-to-opensql-statements--step-by-st...

/ Mats

[#4]

Works perfectly thank you very much Tomas.