Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to use '%LIKE%' to join in Query transformation

Hi Experts,

I need to implement the below join condition in Query transformation.

SQL:

SELECT A.COL1.B.COL3,B.COL4,B.COL7

FROM TABLE1 AS A, TABLE2 AS B

WHERE A.COL2 LIKE '%'+ B.COL2 +'%'

In Query transformation under expression, it is not allowing to add '%' (wild cards). It throws error message.

Also I have tried with lookup_ext function with operartor as ~.

Could you please suggest on this..

Thanks in advance !

Former Member
replied

The concatenation symbol in DS is not "+", but "||".

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question