Issue using the 'ANY Like' in the sql editor

[Idyllic_Data_Geek]

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.

[OllieClarke]

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

[apathetichell]

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