Qlik Community

QlikView Connectors

Not applicable

SAP SQL Connector Like clause

Hi guys,

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

Thanks!

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: SAP SQL Connector Like clause

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

3 Replies
Employee
Employee

Re: SAP SQL Connector Like clause

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

aoi
Contributor

Re: SAP SQL Connector Like clause

Not applicable

Re: SAP SQL Connector Like clause

Works perfectly thank you very much Tomas.

Community Browser