Posted - 11/06/2012 : 11:27:59
| I m trying to join data based on similar strings such as the following:
FROM TAB1 p1
FULL OUTER JOIN TAB2 p2
ON p1.name = p2.name
However, data join only in the case the strings are exactly the same, but will not join if differs, e.g. in the following.
p1.name = 'OLOM production'
p2.name = 'com-OLOM s'
Is it possible to match such cases where only part of the strings match?