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
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
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"
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 record
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?
--
S
