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,