Question: I have a SQL 2000 server with a database (ITinventory) and a table which is also called ITinventory. I would like to create a query which will look at the field 'Status', if the status is 'disposed' then I would like to set a 'location' field to 'disposed'.

Answer: 
```
UPDATE ITinventory
SET location = 'disposed'
WHERE status = 'disposed'

```
```
UPDATE ITInventory SET Location = 'disposed' WHERE Status = 'disposed'

```

This SQL is making various assumptions otherwise not clarified in the OP...