field name be a variable 1

[nnmmss]

i have a procedure like this

CREATE PROCEDURE GetFieldPath @FieldName varchar(10), @ReturnField varchar(10) output
AS
Select @ReturnField=@FieldName FROM TblPath


it doesn't work , i want to have field as a variable to pass it different field
which part is wrong?

 

[bborissov]

CREATE PROCEDURE GetFieldPath
 @FieldName varchar(10),
 @ReturnField varchar(10) output
 AS
  DECLARE @lcSQL nvarchar(300)
  SET @lcSQL = 'SELECT @MyReturnField = '+@FieldName+' FROM TblPath'
--- Change the type of parameter to match you needs
 EXEC sp_executesql @lcSQL, N'@MyReturnField varchar(10) OUTPUT', @MyReturnField = @ReturnField OUTPUT
  SELECT @ReturnField

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.