>>I need to pass a column number to an SP and get the value of that column from a cursor. Currently I have the following;
>
>I would expect that this requirement would create very fragile code. your application is not depending on the sequence of columns in a table. Is there some other solution to your problem?
>
>-Mike

I concur, in this case cursors are created dynamically, so I have both the name and the number at run time. They are partially cartesian by design for an HTML detail report. The trick seems to be to get the value from the cursors field. As is often the case, I didn't get the privilege of designing the system from the beginning. :( I wouldn't have done it this way at all. However, the client is in bed with the process. Its very annoying as it would take 15 seconds in VFP or ADO.