Contains in query def expression

Forum|Forum|6 months ago
July 2, 2025
3 replies
472 views

Hi Team,
Im trying below expression in query def I actually want to try using contains instead of like

Iif(@label LIKE '%labelname1%' OR @2449631 LIKE '%labelname2%','A1' ,Iif(@label LIKE '%labelname3%' OR @2449631 LIKE '%labelname4%','A2','A3' ) )

Could you please help us with correct syntax.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

Hi @vanivi1 ,

You can utilize the 'Charindex' function in expression as below:

Iif(Charindex(@label, 'labelname1') > 0 OR Charindex(@label, 'labelname2') > 0,'A1' ,Iif(Charindex(@label, 'labelname3') > 0 OR Charindex(@label, 'labelname4') > 0,'A2','A3' ) )

The above expression will result the value 'A1' if the label contains 'labelname1' or 'labelname2' and the result will be 'A2' if the label contains 'labelname3' or 'labelname4'. For all the other labels, 'A3' will be the default value.

Ó

ÓscarGo

Level 2

Hi @vanivi1

Assuming you are running Oracle database, this syntax should work:

CONTAINS(<fieldName>, <fieldValue>) > 0;

BR, Oscar

ParthaSarathy

Accepted solution

Community Advisor

Hi @vanivi1 ,

You can utilize the 'Charindex' function in expression as below:

Iif(Charindex(@label, 'labelname1') > 0 OR Charindex(@label, 'labelname2') > 0,'A1' ,Iif(Charindex(@label, 'labelname3') > 0 OR Charindex(@label, 'labelname4') > 0,'A2','A3' ) )

The above expression will result the value 'A1' if the label contains 'labelname1' or 'labelname2' and the result will be 'A2' if the label contains 'labelname3' or 'labelname4'. For all the other labels, 'A3' will be the default value.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups