topic Re: SAP SQL Connector Like clause in QlikView

SAP SQL Connector Like clause

Mon, 26 Jan 2026 21:26:37 GMT

Hi guys,

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

Thanks!

trm — Wed, 18 May 2016 07:09:08 GMT

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 — Wed, 18 May 2016 08:19:00 GMT

You can read about OPEN SQL syntax here :

/ Mats

Thu, 19 May 2016 10:34:47 GMT

Works perfectly thank you very much Tomas.