Try

select log_user.*, location.code , location .name ;
  FROM log_user ;
    JOIN location ON log_user.location LIKE ("%" + TRIM(location.code) + "%");
  into cursor Tmp

>
>
>The data in log_user.location is a character field, i.e. "TS,MT", so it is not a separate record... is there anyway to "divide" TS and MT as records, then join them with code?