Leif,

Here is an example query to get you started, you will probably need to customize it for your scenario.

select up.PropertyValue
from profilepropertydefinition ppd
join userprofile up on ppd.propertydefinitionid = up.propertydefinitionid
where ppd.propertyname = 'Sport'

This joins the profile property definition table with the user profile table and only returns the values for that type of property.

hope that helps!

Take care,

Ian