Oracle query - matching fields

Hello;

I've got an Oracle query question that I hope someone can give me some assistance with. (I'm using 8i personal edition). I have a table which has first initials and last names in it. I have another table which has first initials and last names in it, all capitalized (ie. 'J' and 'SMITH').
Some of the last name columns in one table have an additional space in it (the one which is not capitalized, ie 'J' and 'Smith '). What can I do to get them to match?

This is the SQL statement before trying to solve the above mentioned problem.

select '1' AS TYP, first_initial || '. ' || last_name, Count(*) AS CNT from scoring WHERE date >= '01-Oct-01' AND date <= '14-Apr-02' AND UPPER(first_initial || '. ' || last_name) IN ('J. BLOW','B. SMITH') GROUP BY first_initial || '. ' || last_name, ORDER BY first_initial || '. ' || last_name;

THis will work but will not solve the above mentioned problem

Any ideas,
Tim Received on Sat Sep 21 2002 - 10:53:38 CDT