[support] Search and Replace

[A-NO-NE Music]

Mike Bishop / 2007/06/13 / 05:48 PM wrote:

>In a SQL prompt you could do
>
>UPDATE [table_name] SET [field_name] =
>REPLACE([field_name],'[string_to_find]','[string_to_replace]');

Thank you so much for this.  Actually I chickened out and I ended up
with retyping manually.  I saved your response and put it in my safe.  I
will practice :-)

-- 

- Hiro

Hiroaki Honshuku, A-NO-NE Music, Boston, MA
<http://a-no-ne.com> <http://anonemusic.com>