Multiple Column SubQuery

I need to query out multuple rows of data from the following table and retrieve it as a single row.   Ideally, I'd like to do some sort of subquery that supports multiple columns, but as far as I know, that only exists on Oracle, not MSSQL.

Here's an example of the data:
UserDefinedFieldId     UserDefinedRowID     FieldValue
1                              1                              date (stored as text)
2                              1                              text
3                              1                              text
1                              2                              date (stored as text)
2                              2                              text
3                              2                              text
...27 UserDefinedFieldIds for each row in the actual table

I wrote a working query, but I need something more efficient for this particular application.  (The query to do this must fit in a 2000char data field--with all 27columns brought in with separate subqueries, I'm pushing 5000.)  Already tried shorter table names, which only saved me about a 1000 characters.

SELECT
     (SELECT SecondaryTable.FieldValue FROM UserDefinedData AS SecondaryTable
          WHERE SecondaryTable.UserDefinedRowID = PrimaryTable.UserDefinedRowId
          AND SecondaryTable.UserDefinedFieldId = 1) AS Column1,
     ,,,
     (SELECT SecondaryTable.FieldValue FROM UserDefinedData AS SecondaryTable
          WHERE SecondaryTable.UserDefinedRowID = PrimaryTable.UserDefinedRowId
          AND SecondaryTable.UserDefinedFieldId = 27) AS Column27,
FROM UserDefinedData AS PrimaryTable
WHERE PrimaryTable.UserDefinedFieldId = 5 AND
     Cast(Cast(PrimaryTable.FieldValue AS varchar(64)) AS datetime) > GetDate()
ORDER BY PrimaryTable.UserDefinedRowID, PrimaryTable.UserDefinedFieldId

Any suggestions would be appreciated.

Thanks,

Brad