Fuzzy (Like) Join not working

Question

I have the below code to match on similar characters where possible and it only brings through results from subquery A. Please can someone assist? Thanks

    select 
        * 
    from 
        (
            Select 'Test' T
        )a
        left join
        (
            Select 'Test1' T
        )b
    on
        '%' + a.t + '%' 
    like 
        '%' + b.t  + '%'

You should tag your question with the database you are using. — Gordon Linoff, May 31 '16 at 10:50

score 3 · Accepted Answer · answered May 31 '16 at 10:50

3

The like pattern only goes on the right side of the operator. I think you intend:

on (a.t like '%' + b.t + '%') or
   (b.t like '%' + a.t + '%')

answered May 31 '16 at 10:50

Gordon Linoff

1,242,037
58
646
786

Fuzzy (Like) Join not working

1 Answers1