Thread: Variable like concat variable

I have this code as follows

Code:

EXEC SQL FETCH getContractParamInfo2 INTO :db_sh_param_type,:db_sh_param_value, :db_createDate ,:db_createEndDate, :db_sncode, :db_spcode; 

fetchStatus2 = sqlca.sqlcode;

if(0 == fetchStatus2)
	{
	   ContractParameters tmpContractParam;	

  	   JSTRING_FROM_ORA(tmpContractParam.paramType, db_sh_param_type);
          JSTRING_FROM_ORA(tmpContractParam.paramValue, db_sh_param_value);
 if (tmpContractParam.paramValue LIKE CONCAT('%',tmpContractParam.paramType))  
{
do my things here
}
        }

The code I am trying to do is highlighted in bold and I know it is wrong.

Is there any other way of doing it? If so, is there any code example?