select unencrypted values

Last Post 20 Jan 2007 09:07 AM by trans53. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
19 Jan 2007 06:27 AM
Hi guys,

Here is my question:

For each account I need to select all unencrypted values in a columns like:

account new value old value

1 CZ31gpJaMBfIdmAukvomBw== 1278789
2 4578888 NY78rpKaDKfIdmGukvImBa=


How can i find those that unencrypted? Is there a function that i can use?

Thank you
trans53
New Member
New Member

--
19 Jan 2007 10:58 AM
We do have user defined SP that ecrypts the values calling batch file using blow fish
trans53
New Member
New Member

--
20 Jan 2007 09:07 AM
We do have SP to decrypt the values, my question was how i can select all unencrypted values from the table like :

account new_value old_value

1 CZ31gpJaMBfIdmAukvomBw== 1278789
2 4578888 NY78rpKaDKfIdmGukvImBa=

trans53
New Member
New Member

--
21 Jan 2007 06:34 AM
Exactly,

Thank you
trans53
New Member
New Member

--
21 Jan 2007 12:32 PM
I am sorry for confusion, all unencrypted values stored in a separate column

Thanks
trans53
New Member
New Member

--
22 Jan 2007 04:23 PM
yes, just want to get all unencrypted values from another column
You are not authorized to post a reply.

Acceptable Use Policy