|
rasta
Starting Member
23 Posts |
 Posted - 11/06/2012 : 11:27:59
|
I m trying to join data based on similar strings such as the following:
SELECT p1.*,p2.*
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?
Thanks. |
|
How to join data on similar string patterns
