Hello friends.
In need your help.
I have a table with a field Name: Varchar(255).
In this field Name I have a detail and I need replace in all records a
word for another.
For example: I have vhs and I want to change the word vhs for the
word dvd in all records.
How can I do this?
--
Saludos
update table set field=REPLACE(field, 'vhs', 'dvd');
Gabriel Mahiques [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Hello friends.
In need your help.
I have a table with a field Name: Varchar(255).
In this field Name I have a detail and I need replace in all records a
word
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in vhs format, and I want to
replace IT with Movie Kill Bill Vol 1 in dvd format.
In Another case I have: VHS Trade Konami. . and I want to replace with
DVD Trade
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in vhs format, and I want to
replace IT with Movie Kill Bill Vol 1 in dvd format.
In Another case I have:
Thanks friends.
Duncan Hill escribió:
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in vhs format, and I want to
replace IT with Movie Kill Bill Vol 1