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