This returns the name of the column. I need to get the value from the col. So in the case of our test here the 2nd col is Lastname. I need to return whatever the value is in the lastname col.

Thanks in advance,


>If I understand your question...Try this:
>
>1- Put the variable '@Result' like a new parameter with the 'Output' at the end
>2- and check the execution at the end
>
>================================================
>CREATE PROCEDURE AAA
> @COLNUM smallint,
> @RESULT varchar(100) output
>AS
>
>DECLARE @TESTFIELD varchar(100)
>
>set @TESTFIELD = COL_NAME(OBJECT_ID('Northwind.dbo.Employees'),@COLNUM )
>
>DECLARE Employee_Cursor CURSOR FOR
>SELECT @TESTFIELD FROM Northwind.dbo.Employees
>OPEN Employee_Cursor
>FETCH NEXT FROM Employee_Cursor into @RESULT
>
>CLOSE Employee_Cursor
>DEALLOCATE Employee_Cursor
>
>/* When you will excute your SP
>declare @x datetime
>set @x = null
>execute aaa 1, @x output
>select @x
>*/
>
>Dave
>Technologies Nter