Richard,
Off the top of my head, I'd try something like the following:
SELECT *;
FROM table1;
WHERE name1 NOT IN ;
(SELECT RTRIM(fName) + " " RTRIM(mName) + " " + RTRIM(lName) FROM table2)
>Hi All,
> I have two tables which has records of people with their names. Table1 has the names in one variable, thus: name1="RICHARD NDIVO MUTISO" while Table2 has the names in three different variables, thus: fname="RICHARD" mname="NDIVO" lname="MUTISO".
>
>I want to check that the names in table1 are the same as those in table2 (spelling and all!). How do I go about this? I'll appreciate all the help I get from you guys.
>
>Thanks all in advance.
>
>Cheers, Richard.
Daniel