Query to fetch all the profile value at all levels including both the front end values as well as th

 Hi All,I was planning to write a sql statement which pulls out all the profile options set at all levels that is site , application , responsibility and user.

I have got the query from certain metalink note .

What i observed is that the profile value which is stored in the database is different when viewed from the front end.That is in the front end , it was showing as Yes and at the backend it was storing as Y.

Now my question.

Is there a way for us to show both the front end as well as the back end value of the profile.