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, September 25, 2003 1:38 AM Subject: Help with Transac

RE: Help with Transact SQL

2003-09-25 Thread Kola Oyedeji
Perhaps I'm missing something here but shouldn't a simple update statement suffice e.g. Update sometable Set pathField = '/path1/path2/rest_of_path' Where pathField = 'http://an_absolute_path/new_path_1/path2/rest_of_path ' Or is there more to it? Kola >> -Original Message- >> From: Fra