Hi there,
I wrote the following query which I believe is same but it doesn't yield the same result !
select * from OE.PRODUCT_INFORMATION where product_name in ('HD%','GP%');
select * from OE.PRODUCT_INFORMATION where product_name like 'HD%' or product_name like 'GP%';
So when I write in IN it should still select any product beginning with HD OR GP right ? but that doesn't happen and no result is returned when I execute the one with IN operator
Technically both should give same result right ?
Please guide me here.