This is a multi-part message in MIME format.

------=_NextPart_000_0081_01C203E9.50A725F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

i am having table of 8,000 records.  One of its field(column) is an
encrypted string. The seed for encryption is the other field  of the 
table
itself(that is other field or column of the same record).  Now the user 
will
be typing plain text for searching, i don't have the seed, encrypted
string.....the solutions suggested by the people are

1.  Bring all encrypted string, seed from table and  encrypt the
plaintext with all seeds and compare with corresponding encrypted 
string.
 but it takes 8,000 records to client side and runs thru all 
records....)

2.  Add one more column to the table of plain text, where before
encrypting the plain text mask some characters and store it , so that 
when
the user types the string to be searched , compare it with masked field
pattern and return its corresponding encrypted string, seed values . So 
that
with minimum number of operations the step 1 can be done to find out.
 most people agrees with it....but it needs one more column, partial
expostion of data to the user...we want some better solution
Can u suggest something?

 Thanx & regards,
S.A.Radha.