>Hi,
>
>Is there any way to do one of the following in a trigger?
>
>1 - return the value of a field from inserted/deleted tables where the field name is stored in a variable? i.e.

select MythicalEvalFunction(@MyField) from inserted ....

>
>2 - return the value of a field from inserted/deleted tables where all you have is the field ID (from the corresponding actual table) i .e.

select MythicalEvalFunction(field_id) from inserted ...

>
>TIA,

Ken,

HUH? Would be my response to your questions...

First, what do you mean by RETURN? A trigger is called automatically, who or what are you returning the value to?

Also, what do you mean by the field_id ??? Do you mean the object ID?

Perhaps if you tell us what you are trying to acomplish it would be easier to get you on the right road.

BOb