Contains in query def expression

[VV7]

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

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

Could you please help us with correct syntax.

[ÓscarGo]

Hi @VV7 

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

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

BR, Oscar

[ParthaSarathy · Accepted solution]

Hi @VV7 ,

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.

[Marcel_Szimonisz]

Hello @VV7,

why like cannot be used?

LIKE %xyz% == contains

Marcel