Skip to Content
avatar image
Former Member

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 !

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 31, 2016 at 04:44 PM

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

    Add comment
    10|10000 characters needed characters exceeded