Compare string in two columns (A and B)

Good evening all.
I am trying to compare two string in column A and B and then display the differences in column C

What do you mean by differences? Is there a direct correspondence between the columns on the same row?

Please post a few examples to clarify your problem.

Pete

Hi Pete,

e.g.

Column A has. Select * from hcclco.patient where patient_id = '12345'
Column B has, Select * from hcclco.patient ad pat where pat.patient_id = '12345'

I would like the output to show the differences between column A and B

Essentially the columns contain SQLs from Taradata and Oracle, so trying to show the diffences in syntax between the two dbms.

pls try as fallow

first u need to join table hcclco.patient ( where patient_id =12345) and table hcclco.patient ad pat (where patient_id =12345)
then store the difference of these columns value

select * from hcclco.patient where patient_id = '12345' as a;
Select * from hcclco.patient ad pat where pat.patient_id = '12345' as b;
join a and b on (patient_id = pat.patient_id );
select a,b, a-b as c;

pls let me know if it helps...

I apologize for not being too clear.

bottom line: I am trying to find a Excel function or vba script that can compare strings that are in column A and Column B of an excel spreadsheet and return the differences.

The strings in my case happens to be Teradata and Oracles SQL statements.

So Column A would have a Teradata SQL statement and Column B would have the equivalent Oracle SQL.

background: We are converting from a Teradata platform to Oracle. We converted all the Teradata SQLs to the Equivalent Oracle SQL statement using a tool, which are documented in an Excel spreadsheet (about 283 statements) and are trying to highlight the differences