how to join based on substring in sql query

[venkatesh NV]

how to join based on substring in sql query?

example: i am joind 2 tables first table 175 056 venkatesh
second table 056 venkatesh NV how can i join....

[NeoPa]

Unless you can be more specific about the actual requirements I suspect this is not possible.

The Like comparison allows one whole string to be compared to another sub-string, but you'd need to know exactly what you were trying to compare first. Looking for any unspecified overlap is frankly non-sensical (as that could include something as simple as a space technically).

Please feel free to clarify the question such that it makes proper sense and we can try to help you.

[nbiswas]

Try this

Declare @table1 table(T1Col1 int,T1Col2 int,T1Col3 varchar(50))
Insert Into @table1 Select 175, 056,'venkatesh'
 
Declare @table2 table(T2Col1 int,T2Col2 varchar(50),T2Col3 varchar(50))
Insert Into @table2 Select 056,'venkatesh','NV'
 
Select 
        t1.*
        ,t2.*
From @table1 t1
Join @table2 t2
On t1.T1Col2 = t2.T2Col1
 

Result
------

T1Col1    T1Col2    T1Col3    T2Col1    T2Col2    T2Col3
175    56    venkatesh    56    venkatesh    NV

Hope this helps