Like operator

[dmando84]

Hello,

Does anyone know how to use a like operator with a column? e.g

select name
from table1 1
join table2 2 on table1 = table2
where name like ['%] + 2.name + [%']

I need something like this. Any help would be appreciated.

 

[gmmastros]

select name 
from table1 1
join table2 2 on table1 = table2
where name like '%' + 2.name + '%'

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Catadmin]

Might want to use Ltrim and Rtrim on your column to get rid of leading and trailing spaces, too.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[dmando84]

Thank you!