Thanks Guarddata,

Any suggestions on how I could output this into one select statement. I need to return the result to the application level with one select statement...

Ok, but what I need is to be able to join the result for each column with it's column name. So each row would have the column name and the...

I want to return the field values for the fields that are enabled not just the names of the feilds. Returning field names is the easy part 😉

this might be quicker than the DDL

A query from the first table might return this:

---------------------------------------

SELECT FDT_NAme, F_Description,... FROM tblFDT WHERE F_UID = '12345'

FDT_NAme F_Description FO_XPosition FO_YPosition FDT_UALookup

UA_PHONE Phone Number...