From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-ie0-f181.google.com (mail-ie0-f181.google.com [209.85.223.181]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by mail.server123.net (Postfix) with ESMTPS for ; Tue, 16 Dec 2014 13:22:40 +0100 (CET) Received: by mail-ie0-f181.google.com with SMTP id tp5so12666757ieb.12 for ; Tue, 16 Dec 2014 04:22:38 -0800 (PST) Received: from [192.168.0.10] (d233-64-141-225.dim.wideopenwest.com. [64.233.225.141]) by mx.google.com with ESMTPSA id vf6sm709892igb.6.2014.12.16.04.22.37 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 16 Dec 2014 04:22:37 -0800 (PST) From: bill Message-ID: <549023F9.5000708@TechServSys.com> Date: Tue, 16 Dec 2014 07:22:17 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------020709090104070609050208" Subject: [dm-crypt] Impossible task ? List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: dm-crypt@saout.de This is a multi-part message in MIME format. --------------020709090104070609050208 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit I have conflicting needs and fear that they may be unresolvable. I. I need to store patient names (3 fields: last, first, middle initial) with the first and last names encrypted. 2. I need to be able to do partial name lookups if the user enters a partial first or last name. I presume that after encryption the names are no longer in alphabetical order, so looking up using an encrypted partial name will not result in a set of names beginning with that partial name. Is there an approach to this, or need I go back to my boss and suggest "plan B." -- Bill Drescher william {at} TechServSys {dot} com --------------020709090104070609050208 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit I have conflicting needs and fear that they may be unresolvable.
I. I need to store patient names (3 fields: last, first, middle initial) with the first and last names encrypted.
2. I need to be able to do partial name lookups if the user enters a partial first or last name.

I presume that after encryption the names are no longer in alphabetical order, so looking up using an encrypted partial name will not result in a set of names beginning with that partial name.

Is there an approach to this, or need I go back to my boss and suggest "plan B."

-- 
Bill Drescher
william {at} TechServSys {dot} com

--------------020709090104070609050208--