View Single Post
Old 22-Oct-2007, 12:37 AM   #2 (permalink)
Anilrgowda
Administrator
 
Anilrgowda's Avatar

Posts: 18,715
Join Date: Jan 2006
Rep Power: 10 Anilrgowda is on a distinguished road

IM:
Default Re: Need a SQL query to replace values in a certain field

update table1
set staff = 'vs'
where staff = 'bc'


------------------


Anilrgowda is offline   Reply With Quote