Error - View Single Post - Need a SQL query to replace values in a certain field

**Anilrgowda** · 22-Oct-2007, 12:30 AM

Question: I need to update a table in SQL 2000. I have a table named table1 and a field named staff. I would like use a query to change all the values under staff that has a value of 'bc' to 'vs'. Seems like it should be fairly simple but I have just started working with SQL.

22-Oct-2007, 12:30 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Need a SQL query to replace values in a certain field Question: I need to update a table in SQL 2000. I have a table named table1 and a field named staff. I would like use a query to change all the values under staff that has a value of 'bc' to 'vs'. Seems like it should be fairly simple but I have just started working with SQL. ------------------