Avatar of Sam OZ
Sam OZ
Flag for Australia

asked on 

sql server search a table field like another table field

I have two sql server 2016 tables Table1 , Table2   with a fled myName in both filed
How can have a query that looks a table1 myname like table2 myname
I tried table1.myName like '%'  ||  table2.myName || '%'    but that seems to be not correct
DatabasesMicrosoft SQL ServerSQL

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon