How to make a SELECT with a field name inside a variable??

Question

I have a table (for example PERSONS) with several fields (NIF NAME AGE).
I have a cursors than read the differents fiels tat have this table inside a trigger fron another table that contain all the fields of the tables.
This cursor save the name of the fiels inside the variable @FIELD.
I need to read the value of the several records of the table like:

@FIELD='NIF'   <--(CURSOR)

SELECT @FIELS FEOM INSERTED  --> select nif from inserted(persons)

This sentence doesn't works. How can I do?

Thanks, Otto Martinez.

Answer 1

Hi,
you maye use a variable to generate the whole statement then use the exec command
Declare @sql NVarchar(200)
set @sql= "Select " + @Fiels +" from inserted"
exec @sql