SQL Server Performance Forum – Threads Archive

Need a script

Hi All, I wan to manipulate string values to protect the identity of the original value. For example I have column which contain Names. I need to change the names unique to a certain extent. For example I have row value "ANIL", I want to change that value to may be "BMJM" which means replacing the alphabet with next coming one (A with B and N with M) so that the original name should be protect the identity of original name.
The script can be vary it by substituting characters in either name, add or remove characters, etc. Anything that will make the names somewhat unique. Is it possible to do so? Please help me!!! Thanks in advance Regards,
Anil Kumar

---

Not really a question for the "clustering" section, I would think.

---

Sorry for that. I didn’t see the scetion. When I opened link which already in my favorates, it opened this section and in a hurry I just posted without checking the section. Regards,
Anil Kumar

---

Looks like you need some sort of encryption. Shifting the characters one position in the alphabet may be too easy.

---

hi thanks 4 responce could u be more specific how to do that plz. Even an overview of the script would be of great help!!!! Regards,
Anil Kumar

---

]]>