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: 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 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:138422 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com