Skip to Content
0
Former Member
Jul 29, 2016 at 09:19 AM

How to use LIKE operator with string retrieval argument

1635 Views

Hi All,

(With PB12.5 here)

I have a datasource, which is with string retrieval argument (arg_1) in where clause.

When use LIKE operator, it seems not working, but the query is working fine with = operator.

Fyi, I did tried the following

1. .....where col_name like '%' || :arg_1 || '%'

2. .....where col_name LIKE :arg_1 + '%'

Kindly advise.

Thank you in advance.

BR,

Yow