SQL: is where name like %columnName% possible

Question

I am aware of using where and like this

select * from Table1
join table2
on table1.column like %text%

i want to extend the same logic to the column. i.e

select * from Table1
join table2
on table1.column like %table2.column%

This is impossible on SQL? is there an alternative for this?

Thanks

What RDBMS is this for? Please add a relevant tag to your question! — marc_s, Mar 09 '15 at 05:14
Hi Marc, I am working on SAS EG. I am using Proc-Sql on SAS EG — maverick, Mar 09 '15 at 10:16

G B · Answer 1 · 2015-03-09T19:44:14.813

Try to get into the habit of always specifying the DB engine you are using and including sample data and expected output based on that sample data. In this case the sample data etc can help us provide a more relevant answer. there may be a better solution to your problem than using like in your join clause.

but for the simple example you have given the below should work.

select * from Table1
join table2
on table1.column like '%' + table2.column + '%'

EDIT From this resource it seems proc-sql uses double pipe || for string contatenation and double quotes for strings so try the new version below.

select * from Table1
join table2
on table1.column like "%" || table2.column || "%"

I have added a more relevant approach to this answer. – G B Mar 10 '15 at 09:41 — G B, Mar 10 '15 at 09:41

score 0 · Answer 2 · edited Mar 09 '15 at 20:15

0

Try this

select * from Table1
join table2
on table1.column like '%' + table2.column + '%'  COLLATE Latin1_General_CS_AS

where (COLLATE Latin1_General_CS_AS) stands for case sensitive in Microsoft SQL Server

edited Mar 09 '15 at 20:15

answered Mar 09 '15 at 05:53

SimarjeetSingh Panghlia

2,200
13
14

Hi Simarjeet, Thanks for the reply. Will try this out – maverick Mar 09 '15 at 10:17

SQL: is where name like %columnName% possible

2 Answers2