Re: subnstr-function

Use the Replace function In Oracle:

update your_table set your_field_with_dotnotation = replace(your_field_with_dotnotation,'184.96.244.3',mysite.com);

This will check each record in that table and if the that field has those characters in it, it will change them to the new entry, if not, it will do nothing and move on to the next record

"Gomber_at_Home" <sgomber_at_adlink.net> wrote:

>Hello Scott
>
>Scott Mattes wrote:
>
>> Use 'instr' to find where the string starts, substr up to that point, put in
>> the replacement, followed by a substr of everything after the replaced
>> string
>
>since i'm still very new on that stuff how would you set up the syntax for your
>example if you have to exchange the following:
>
>http://a1168/f/h/solution.net/184.96.244.3/Switzerland/Crossair/QFGE.gif
>where 184.96.244.3 should be replaced with mysite.com ?
>
>thanks for your help
>
>Sven
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Jul 18 2001 - 16:00:07 CDT