RSA Scripts

Scramble Data

  1. Sql Server
  2. String manipulation
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

update member
   set ShemMishpacha = 
    substring(ShemMishpacha,2,1)+
    substring(ShemMishpacha,1,1)+
    substring(ShemMishpacha,convert(int,rand()*len(ShemMishpacha)-1),1)+
    substring(ShemMishpacha,convert(int,rand()*len(ShemMishpacha)-1),1)+
    substring(ShemMishpacha,convert(int,rand()*len(ShemMishpacha)-1),1),
    ShemPrati = 
    substring(ShemPrati,2,1)+
    substring(ShemPrati,1,1)+
    substring(ShemPrati,convert(int,rand()*len(ShemPrati)-1),1)+
    substring(ShemPrati,convert(int,rand()*len(ShemPrati)-1),1)+
    substring(ShemPrati,convert(int,rand()*len(ShemPrati)-1),1)