Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickStan
Starting Member
36 Posts |
 Posted - 2007-09-05 : 11:55:42
|
Hi AllI am running a DTS package every hour that does an import from our Oracle database in our SQL server (2000) database.The problem is that one of our fields is URL encoded, like this 574774116%3B150155138873I need to find a way to decode this field either in Oracle or SQL.I found some code on the internet for Oracle URL decoding but it did not work.  Does anyone know of a way to do this in SQL?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-05 : 11:58:19
|
SELECT REPLACE(Col1, '%3B', ';')FROM Table1
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
How do I do URL decoding in SQL?