|
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]
|