Carleton (12/23/2009)

---

If you are unsure if the field contains a wildcard character when joining using the LIKE operator, you can avoid false positive results by observing this tip:

Hugo Kornelis (12/24/2009)

---

But what is the point of using LIKE if you do this? Why not simply use the = operator?

select * from #table1 t1 
inner join #table2 t2 
on t1.Col1 like 
'%' + REPLACE(REPLACE(t2.Col1,'%','[%]'),'_','[_]') + '%'

Chris Carter-210078 (12/30/2009)

---

The complete answer should be “It depends”. If you have a case sensitive collation designator you will get:
Msg 208, Level 16, State 0, Line 3
Invalid object name '#table1'.
Since the script created a table #Table1 and tries to reference #table1