Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Solution

Accepted Solutions
trm
Employee
Employee

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

View solution in original post

3 Replies
trm
Employee
Employee

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

View solution in original post

mats_olin
Employee
Employee

Not applicable
Author

Works perfectly thank you very much Tomas.