How about:

REPLACE myTable WITH IIF(this=1 OR that=2,new_value, otherwhise)

>table1.costctr needs to be converted to a new value. If have put the pseudo code below but would like to do it in an SQL statement.
>
>if table1.costctr = costctr.o_costctr and
> control.site_id = costctr.site_id
>replace table1.costctr with costctr.n_costctr
>endif
>
>table1 has about 1000 records, and a couple hundred fiels
>costctr has about 8000 records and only a couple of fields
>control has only 1 record and only a couple of fields
>
>
>thanks
>
>Brenda