14 Jun
2007
14 Jun
'07
5:04 a.m.
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