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 |
|
mrmarmelad
Starting Member
1 Post |
 Posted - 2005-11-30 : 10:35:53
|
| I have a table with a bunch of "%u00XX" (WHERE 'XX' represents ASCII hexadecimal value of the special character such as 3A for ":" or 2F for "/" etc.) The data looks like that:<http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom> For a quick and derty way of reformatting that data I wrote a simple REPLACE statement:SELECT REPLACE( REPLACE( REPLACE(REPLACE(myTable,'%u003A',':'),'%u002F','/'),'%u002E','.'),'%u002D','-'), which works fine but requires all special characters to be listed: ?,%-&$ etc. This giant SELECT obviousely does not look efficient. Any help in decoding that string into http://www.google.com would be really appreciated. |
|
|
|
|
|
Quad Special Charachter Unicode Encryption