how to compare two columns and return the value which is not matched

[pratyushavasireddy]

i need to compare two columns .and return the result which is not matched.
for example
if i have pratyusha in one column and pratyusha vasireddy in other column.when i compare two columns i should get a result of vasireddy.
thx in advance

[debasisdas]

you need to use some character functions for the purpose.

[r035198x]

The INSTR function may be useful here.