query inside like operator

Question

Can I use query inside the like operator.

I used the query below, but it returns error.

select * 
from customers
where cust_name like '%'||select name from members||'%'

Answer 1

Something like the following should work :

SELECT
 *
FROM
 customers    c
WHERE 1=1
AND EXISTS
 (SELECT 1
  FROM members   m
  WHERE 1=1
  AND c.cust_name LIKE '%'||m.name||'%'
 )