Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

Works perfectly thank you very much Tomas.