Issue using the 'ANY Like' in the sql editor

Question

Hello,

I'm using a query to extract data based on some keyword strings. The query that I used is something like

select a,b,c,d,e,f

from abcd

where e like any

('TREA 000%','%TREA 010%',
'%XXSOC SEC%','%XXVA BEN%',     '%XXSUPP SEC%','%XXCIV%')

Although, alteryx is able to initially parse the query successfully . But, When I try to use this data source it is throwing me an error.

apathetichell · Answer

what's the datasource and what's the error message?

OllieClarke · Answer

Hi @Idyllic_Data_Geek can you give us a bit more information please? To what datasource are you connecting? Can you give a screenshot of the error, and/or give us the error text itself?

Thanks