field as a variable

[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?

 

[johnwm]

This appears to be some flavour of SQL rather than VB6 - you will do better if you post in the forum for your particular database. Use the 'Find a Forum' search at the top of each page. faq222-2244 will also provide general guidance on forum usage

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller