ENCRYPTED FIELD

[Richard Kreiss]

> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-
> list-bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Kenneth
> Brody
> Sent: Wednesday, October 28, 2009 12:04 PM
> To: rkreiss at gccconsulting.net
> Cc: 'filePro List'
> Subject: Re: ENCRYPTED FIELD
> 
> Richard Kreiss wrote:
> >
> > I have an encrypted field of 20 characters which decrypted would be
numbers.
> >
> > Anyone have an easy way to test the value to see if it is encrypted
since
> > there is no guarantee that any specific graphics character would be
> > present.
> >
> > Based on the values I am looking at it appears I need to test for
characters
> > in the following dec ranges:
> [...]
> 
> There is no guarantee AFAIK that encrypting a field containing only
numbers
> will result in a field containing something other than only numbers.
> 
> --
> Kenneth Brody


I ran a test on 8,000 records in this file and when encrypted no value was
all numbers.

As I mentioned to Mark, all I was saying is that a numeric value may be
present in the encrypted value.  Therefore a test for a numeric value would
not be valid for testing for an encrypted value.

Richard