SQL Server Performance

Need a script

Discussion in 'SQL Server Clustering' started by Anil, Nov 1, 2006.

  1. Anil New Member

    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
  2. Adriaan New Member

    Not really a question for the "clustering" section, I would think.
  3. Anil New Member

    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
  4. Adriaan New Member

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

    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

Share This Page