Join two tables if the string col from one is substring from the other(Big dara set)

[Barney1998]

Hallo to everyone,

I have one problem with below procedure!

I have one table A with one column a and one table B with one column b ,the column a from the A is substring from the column b from the B.I wanna to joint that tables .As result i want one table which have only the rows from the B which contain some  column from table A as substtring. I have one really big data set and i dont have the ability to check case by case .With other words i looking for one type of order like:the where variable from data statement where A.variable  like ''B.variable2'';

Thanks in advance,

Barney  

[Aku]

I would recommend transposing both tables into hyper normalized format. Then compare "Value -columns" and select "ID-values" when there is a match.

[Reeza]

Show some examples. If the substring is always at the beginning the =: operator may work. 

[Ksharp]

Try to use CONTAINS operator:

 where A.variable  contains strip(B.variable2) ;