Hi. I thought it might be better to add this supplemental question here to keep the correspondence together.

I successfully got your query working :-
SELECT `id`, CONCAT( `firstname`, ' ', `lastname` ) AS name
FROM `#__comprofiler`
WHERE `cb_shac_role` LIKE '%Office%' OR `cb_shac_role` LIKE '%Befriender%'

This allows the selection of user2 in the record of user1 and allows its display in a CB List, but what I am trying to do now (and failing) is to use a similar query to display the avatar of user2 in the record of user1 and similarly to display it in a CB List.

Can you point me in the right direction please?

Thanks a lot

Jim

Thanks so much - worked a treat! I was also able to pull in a contact number using the same approach.

Jim