Re: Help with Transact SQL

2003-09-25 Thread Frank Mamone
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>>> -

Re: Help with Transact SQL

2003-09-25 Thread Mahmut Basaran
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

RE: Help with Transact SQL

2003-09-25 Thread Kola Oyedeji
; -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

Help with Transact SQL

2003-09-24 Thread Frank Mamone
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