You are here: Re: Need a So-Called SSN Encryption « MsSQL Server « IT news, forums, messages
Re: Need a So-Called SSN Encryption

Posted by Mike C# on 05/18/06 03:58

SHA hash function:
http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart4.asp
Encryption functions:
http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp

<ILCSP@NETZERO.NET> wrote in message
news:1143739733.710415.9180@z34g2000cwc.googlegroups.com...
> Hello, perhaps you guys have heard this before in the past, but here is
> what I'm looking for.
>
> I have a SQL 2000 table with Social security numbers. We need to
> create a Member ID using the Member's real SSN but since we are not
> allowed to use the exact SSN, we need to add 1 to each number in the
> SSN. That way, the new SSN would be the new Member ID.
>
> For example:
>
> if the real SSN is: 340-53-7098 the MemberID would be 451-64-8109.
>
> Sounds simply enough, but I can't seem to get it straight.
>
> I need this number to be created using a query, as this query is a
> report's record source.
>
> Again, any help would be appreciated it.
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация