Re: SQL*Plus /Oracle Forms

I think the solution might be found in a combination of tricks: 1.-First you may find useful function SOUNDEX, it works like this: SQL> select soundex('smith'),soundex('smidt')   2 from dual;

SOUN SOUN
---- ----
S530 S530

2.-Second may be QBE is the right tool
select *
from table
where name_in_the_table like '%SMITH'

QBE: Query By Example a very working and useful tricks available in SQL

3.-Third. You may use function INSTR(string1,string2) . It work like this: It renders the position of string2 in string1 if it is there.

SQL> select instr('1234','1')
  2 from dual;

INSTR('1234','1')

                1

SQL> edit
Wrote file afiedt.buf

  1 select instr('1234','2')
  2* from dual
SQL> / INSTR('1234','2')

                2

4.-If you have to process the whole set of rows coming in the official file, then you will have to make sure all the records have been processed. That is something to be
done by you.

Good Luck!
Norberto Pontt
:-)

"Patterson" <r_patterson_at_cox-internet.com> escribió en el mensaje news:tceljp8ookg89c_at_corp.supernews.com...
> How can I compare last name for people in two different tables?
>
> A problem arises when people have a hyphenated name:
> for example, in one table the last name may be Long-Smith
> and in the other table it may be just Smith.
>
> Another problem that I've run into is if the person's name is mispelled in
> one table:
> for example, in one table the last name may be Christopher and mispelled
 in
> the other table as Christophe
>
> What I am trying to do is clean up the "bad" table. One table is
 updloaded
> monthly so the data in that table is "official". However, in the other
 table
> a user can add people to it (which may duplicate a person because they
> didn't see the name in the LOV the way they wanted it displayed (such as
 an
> alias name)
>
>
>
>
Received on Wed Apr 04 2001 - 17:09:28 CEST