Thanks EVERYONE

Actually the problem is this
I just got a delimma in our TRAVEL-BLACKLIST inquiry system....
we have a DEROGATORY table (FIRSTNAME(not null),MIDNAME, LASTNAME(not null),...ect)

We usually DERO-CHECK an alien thru his names, and the program must
adjust or accomodate most encoding errors done by the ecoders.

Example the Name(chinese)
XIU ZHU CHUANG (fisrtname,midname,lastname respectively).

The encoder encode it as:

Fistname='Xiu zhu'
midname=null
Lastname='chu ang'

How can i program and hit this kind of combination error?
Or any advice what constraints can possibly add to minimize char
encoding error and speed-up data search?

Thanks a lot...