Use the description of an UDF in a query

[former_member219719]

Hi all,

I have create a UDF and I haven´t linked a User table to it. I have insert some values for it.

I´m trying to do a query where appears the descriptions of these values, but I can only show in the query the value. Is it possible to show the values and the descriptions or not?

[former_member219719 · Accepted solution]

Thank you very much, but what I want to see is not the name of the table.

What I want see is the descriptions of the values fields in the UDF.

Thanks.

Emilio

[former_member204969 · Accepted solution]

You can use the table UFD1. It contains the codes and descriptions for the values of user defined fields.

[former_member583013]

The UDF Name can be referenced by JOINING the CUFD table which stores the User Fields.

Use this SQL to see the data SELECT T0.TABLEID, T0.ALIASID, T0.DESCR FROM [DBO].[CUFD] T0

Suda