Hi All,
I have data like the below in a table column and I want to write a query to fetch rows like below but it always asks me to enter the value for B. Could you please suggest how I can write it in IN clause?
WITH t AS (SELECT 'A:B' c FROM DUAL UNION ALL
SELECT 'A&B' c FROM DUAL UNION ALL
SELECT 'AB' c FROM DUAL UNION ALL
)
SELECT * FROM t
WHERE c IN ('A:B', 'AB', 'A&B');