Forum Discussion

BADDULA's avatar
BADDULA
Copper Contributor
Mar 31, 2025
Solved

Sql query with Wildcard search

I have two tables: Table1 and Table2. I want to retrieve records from Table2 that match a specific pattern in a column based on data from Table1.  
  • olafhelper's avatar
    olafhelper
    Apr 01, 2025

    Should be easy:

    SELECT *
FROM Table1 AS T1
     INNER JOIN
     Table2 AS T2
         ON T1.ConvertColumn LIKE N'%' + T2.Refrence + N'%'

     

olafhelper's avatar
olafhelper
Bronze Contributor
Apr 01, 2025

Should be easy:

SELECT *
FROM Table1 AS T1
     INNER JOIN
     Table2 AS T2
         ON T1.ConvertColumn LIKE N'%' + T2.Refrence + N'%'

 

Resources