I'm messing around with "SQL Pass-Through" and I'm able to pull data pretty easily but how would I UPDATE data in a SQL Server 2000 table using SQL Pass-Through?

here is my select statement, which works well.

m.nConnectionHandle = SQLCONNECT('TimeClockPlusTest')
m.cSelectedJob = '16536%'

TEXT TO lcCmd NOSHOW PRETEXT 15

select CostRecordId, Level1, Active from dbo.MasterCostCodeList  where level1 like ?m.cSelectedJob

ENDTEXT

=SQLEXEC(m.nConnectionHandle,lcCmd,'CostCodeInfo')

=SQLDISCONNECT(m.nConnectionHandle)

What I'd like to update

UPDATE MasterCostCodeList SET Active = 1 where level1 = ?m.cSelectedJob