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: 
Try this:

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

```
```
update ITinventory
set location='disposed'
where status ='disposed'

```