MAIL PROTECTED]>To: "CF-Talk" <[EMAIL PROTECTED]>Sent: Thursday, September 25, 2003 9:41 AMSubject: 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>>> -
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, Sep
; -Original Message-
>> From: Frank Mamone [mailto:[EMAIL PROTECTED]
>> Sent: 24 September 2003 23:38
>> To: CF-Talk
>> Subject: Help with Transact SQL
>>
>> Hi,
>>
>> I need help with an update query using transact SQL.
>>
>> I
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
4 matches
Mail list logo