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

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.

[557 byte] By [OttoMartinez] at [2008-2-15]
# 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
Eisa at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...

SQL Server

Site Classified