>>
>>

>>lcField = field(nColumn)
>>update mytable set &lcField = 222 where MyField = "SomeValue"
>>

>
>A follow up question, if I may. If/when I move my DB to SQL Server, will there be a way to maintain the same table structure (relying on column no)?

No, If you use SPT.
SQL Server has no such function as FIEDLS() and no macros.
Of course you could build a dynamic SQL based on INFORMATION_SCHEMA.COLUMNS:

DECLARE @lcSQL varchar(200)
SELECT @lcSQL = 'update mytable set ' + COLUMN_NAME + ' = 222 where MyField = ''SomeValue'''
       FROM INFORMATION_SCHEMA.COLUMNS
WHERE Table_Name = 'mytable' AND Ordinal_Position = @nColumn -- Where nColumn is a column number
EXEC (@lcSQL)

not tested at all :-)

So in VFP you could use something like this:

mColumn = 1

TEXT TO lcSQL NOSHOW TEXTMERGE
     DECLARE @lcSQL varchar(200)
     SELECT @lcSQL = 'update mytable set ' + COLUMN_NAME + ' = 222 where MyField = ''SomeValue'''
            FROM INFORMATION_SCHEMA.COLUMNS
     WHERE Table_Name = 'mytable' AND Ordinal_Position = <<nColumn>>
     EXEC (@lcSQL)
ENDTEXT

IF SQLEXEC(...., lcSQL) < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

But if you use CA or Remote view to handle data, there is no need of any of these. You could update VFP cursor and than just use TABLEUPDATE().