Posted by ILCSP on 03/30/06 20:28

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.

• Next in forum: Re: Need a So-Called SSN Encryption
• Prev in forum: Update SQL 2000 Query (converting an Old Access 2k query to SQL)
• Thread view: Need a So-Called SSN Encryption

[Reply to this message]