"Roar Johnsen" <roar@afgruppen.com> wrote in message
news:bqfv78$56p$1@services.kq.no...
> Can anyone help me with the following problem:
>
> I have a database with a column containing long text-values. Inside theese
> textvalues there are som url's that I need to change, or atleast part of
> them.
>
> What I need is a SQL query which updates only part of the text-streng. The
> url's point to an old internal web-server. The text streng http://afintra
is
> to be replaced with http://af-web-int.
>
> I have managed to select the values containing the text string with the
like
> expression, but how do I update just this part of the value??
>
> Hopefully this is like a piece of cake for some of you :-)
>
>

"Roar Johnsen" <roar@afgruppen.com> wrote in message
news:bqg71e$3vp$1@services.kq.no...
> Thanks for your replay John!
>
> I've found this REPLACE function, but I don't understand how to use it.
>
> If I'm right, I'm supposed to, somehow, replace the string_expression1
with
> the data I wan't to change. I've tried to use a select function but It
won't
> work...
>
> I also tried the "search & replace" routine, but it doesn't seem to scan
the
> text-columns.
>
> Roar
>
>
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:OFfjZ7DuDHA.3256@TK2MSFTNGP11.phx.gbl...
> > Roar,
> > T-SQL REPLACE can do this. See SQL Server 2000 BOL title "REPLACE" -
> > syntax - "REPLACE ( 'string_expression1' , 'string_expression2' ,
> > 'string_expression3' )"
> >
> > A more complex example of doing a "search & replace" can be found at:
> > http://vyaskn.tripod.com/sql_server_search_and_replace.htm
> >
> > Regards,
> > John
> >
> >
> >
> > "Roar Johnsen" <roar@afgruppen.com> wrote in message
> > news:bqfv78$56p$1@services.kq.no...
> > > Can anyone help me with the following problem:
> > >
> > > I have a database with a column containing long text-values. Inside
> theese
> > > textvalues there are som url's that I need to change, or atleast part
of
> > > them.
> > >
> > > What I need is a SQL query which updates only part of the text-streng.
> The
> > > url's point to an old internal web-server. The text streng
> http://afintra
> > is
> > > to be replaced with http://af-web-int.
> > >
> > > I have managed to select the values containing the text string with
the
> > like
> > > expression, but how do I update just this part of the value??
> > >
> > > Hopefully this is like a piece of cake for some of you :-)
> > >
> > >
> >
> >
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:OFfjZ7DuDHA.3256@TK2MSFTNGP11.phx.gbl...
> Roar,
> T-SQL REPLACE can do this. See SQL Server 2000 BOL title "REPLACE" -
> syntax - "REPLACE ( 'string_expression1' , 'string_expression2' ,
> 'string_expression3' )"
>
> A more complex example of doing a "search & replace" can be found at:
> http://vyaskn.tripod.com/sql_server_search_and_replace.htm
>
> Regards,
> John
>
>
>
> "Roar Johnsen" <roar@afgruppen.com> wrote in message
> news:bqfv78$56p$1@services.kq.no...
> > Can anyone help me with the following problem:
> >
> > I have a database with a column containing long text-values. Inside
theese
> > textvalues there are som url's that I need to change, or atleast part of
> > them.
> >
> > What I need is a SQL query which updates only part of the text-streng.
The
> > url's point to an old internal web-server. The text streng
http://afintra
> is
> > to be replaced with http://af-web-int.
> >
> > I have managed to select the values containing the text string with the
> like
> > expression, but how do I update just this part of the value??
> >
> > Hopefully this is like a piece of cake for some of you :-)
> >
> >
>
>