Why won't my query work?

[kgkane]

SELECT * FROM table WHERE columname1 LIKE '%' + columname2 + '%'

How do I get this type of query to work?


Kevin

 

[kgkane]

OK let me clarify a little more here. Here's essentially what I'm trying to do in MSSQL:

UPDATE Table1 SET col001 = table2.Col007 FROM Tabl1 JOIN Ntable2 ON (Where the text in table1.col002 can be found in table2.col001)

Hope this helps. Again thanks in advance for any help/suggestions.


Kevin

 

[JamesLean]

UPDATE t1
SET col001 = t2.col007
FROM tabl1 t1 JOIN ntable2 t2 ON t2.col001 LIKE '%' + t1.col002 + '%'

--James