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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138423 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
