SQL using contains or Like '%%' and IN together

Question

is there any way to write SQL query where we can perform contains Check on a column to a sub query/function

i.e. in this manner

select * from where COLUMN contains IN (select * from func)

or

select * from where '%'+ COLUMN + '%' IN (select * from func)

Palanikumar · Answer 1 · 2015-11-26T07:13:15.730

2

Try This,

Select * From  table_name A
Where Exists (Select *  From table_name B 
                 Where B.Column Like '%' + A.Column +'%')

edited Nov 26 '15 at 07:13

answered Nov 26 '15 at 07:04

Palanikumar

I think this is the closest to what OP wants. – Giorgi Nakeuri Nov 26 '15 at 07:24

score 0 · Answer 2 · answered Nov 26 '15 at 07:07

Reviewed my answer because I seem to misunderstood the question

    Select a.*
    from foo a,
    (select * from func) b
    where a.id = b.id or a.id like '%'+convert(varchar,b.id)+'%'

This will select records where A result set column id is equal or like %b.id%

2 Answers2