I'm trying to parse the aspnet_Profile.PropertyValuesString in a SQL query to seperate values. Can anyone help?
I've triied:
SELECT
Users_1.userid,
fn_GetProfileElement('Street', PropertyNames, PropertyValuesString) AS Street,
fn_GetProfileElement('City', PropertyNames, PropertyValuesString) AS City,
fn_GetProfileElement('Region', PropertyNames, PropertyValuesString) AS Region,
fn_GetProfileElement('Country', PropertyNames, PropertyValuesString) AS Country,
fn_GetProfileElement('PostalCode', PropertyNames, PropertyValuesString) AS PostalCode,
fn_GetProfileElement('Telephone', PropertyNames, PropertyValuesString) AS Telephone
FROM
Users Users_1 INNER JOIN
aspnet_Users aspnet_Users_1 ON Users_1.username = aspnet_Users_1.username INNER JOIN
aspnet_Membership aspnet_Membership_1 ON aspnet_Users_1.userid = aspnet_Membership_1.userid INNER JOIN
aspnet_Profile aspnet_Profile_1 ON aspnet_Profile_1.userid = aspnet_Membership_1.userid
but I get a error saying that the fn_GetProfileElement is not a recognized function name.