Error 3544: Partial string matching requires character operands

[btrini]

Hey guys,

I run the below code and get the error "3544: Partial string matching requires character operands"

Not sure why since both fields are character fields. I tried to Cast to ensure they are character.

Any help would be appreciated.

Select * From BA_HARD_HOLD BA
Left Join BMGPEMP.EMP_DY_CURR_HR HR ON (CAST(HR.FULL_NAME AS VARCHAR(250)) LIKE '%' + CAST(BA.FNAME AS VARCHAR(100)) + '%') AND (CAST(HR.FULL_NAME AS VARCHAR(250)) LIKE '%' + CAST(LNAME AS VARCHAR(100)) + '%') AND HR.AU_NUM = 2918;

Thanks