Contains in query def expression

Question

Hi Team,Im trying below expression in query def  I actually want to try using  contains instead of likeIif(@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.

ParthaSarathy · Accepted Answer

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.

Marcel_Szimonisz · Answer

Hello @vanivi1,why like cannot be used?LIKE %xyz% == contains Marcel

Sign up

Login with SSO

Login to the community

Login with SSO