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 |
|
sqldev80
Yak Posting Veteran
68 Posts |
 Posted - 2006-05-25 : 15:30:07
|
| I have some data in my table which is like customerIDI create a url from that www.url.com/image/customerid.htmlnow say if the customerid is like 12345 and i want to encrypt it when i run the query to generate the URL. Is there any way to do that.Also I want it to un-encrypt when I want. I am not sure how this can be done. But if there is a way let me know. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-05-25 : 15:41:42
|
| I think u may need to write code to do thatLong time back, I did something like follows as the algorithmeg. Add ASCII 100 for the first character, 110 for the second 112 for the 3rdAgain 4th character add ASCII 100, 110 for the fifth 112 for the 6th ...After each multiple of 3rd character, an additional character of adding ASCII 115 to the string.U can have any other ASCII values (make sure u r in the ASCII range)When u decrypt, use the reverse routineSrinika |
 |
|
|
|
|
|
Encryption of data