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?
--sb--