which I eventually found. I never used functions in SQL before so that's why
I wasn't sure.
I apologize if I wasn't totally clear.
-Frank
----- Original Message -----
From: "Mahmut Basaran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 9:41 AM
Subject: Re: Help with Transact SQL
> you can use the following to update all rows at once:
>
> update tablename
> set uri_column = 'http://etc.com/etc' + uri_column
>
>
> ----- Original Message -----
> From: "Frank Mamone" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, September 25, 2003 1:38 AM
> Subject: Help with Transact SQL
>
>
> > Hi,
> >
> > I need help with an update query using transact SQL.
> >
> > I need to modify the data in record set in the following way.
> >
> > The field contains a URL like this:
> >
> > /path1/path2/rest_of_path
> >
> > I need to change it to:
> >
> > http://an_absolute_path/new_path_1/path2/rest_of_path
> >
> > So everything stays the same from path2 on.
> >
> > Thanks in advance for your help.
> >
> > Frank Mamone
> >
> >
> >
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
