I have a problem. There's a SQL database on my machine, I have an ASP program for downloading MP3s. There's an column for the MP3's URL in some table.
There's a lot of MP3s located in the same machine, and this machine changes is URL now.
How can I cahnge all URLs in SQL database, into new URL ?
I look for the " Update " statement in SQL, but the example shows update the whole field in the column, but I want to update partial of the URL string only.
For example: There's serveral records in table mp3 , column URL :
Topic Locked
Posted - 04 July 2002 : 10:38:19
