Thanks hun.....but there are still some records that can not be hit...

I want something that uses the "like" function... as in:

select x.empname, y.fullname from EMP x, LOANS_TABLE y
where y.fullname like '%TOM%' and y.fullname like '%WELLING%');

Can u help me split the empname to be similar to the above form?


Thanks again