Select Column Value As Title

I have a table that is a very general layout so I can expand upon values later in the future easily. Basically it looks like this:

Code:

ID PlayerID Ability Score
1 1 STR 18
2 1 DEX 17
3 1 CON 16



What I'm trying to do is create a stored procedure where I pass in a PlayerID and it will return a result set of

Code:

STR DEX CON
18 17 16



It doesn't appear that there's a way in SQL Server 2000 to SELECT a column AS a variable. I suppose I could go about creating a temporary table, but seems like an odd work around to get it to work. Any suggestions? Or am I just missing something obvious?