LIKE operator is not fetching results in oracle

Question

I want to get the results by applying LIKE operator. But its not giving me the result.

Below is my Query.

Select * from TBL_ZONAL_HEAD_INFO where upper(ZONE_HEAD_NAME) LIKE '%ami%';

The above query is not fetching me any results from the data below

Query in procedure

Select * from TBL_ZONAL_HEAD_INFO where upper(ZONE_HEAD_NAME) LIKE '%' || upper(P_ZONENAME) || '%';

Answer 1

You have to match it with UPPER CASE.

SELECT
    *
FROM
    TBL_ZONAL_HEAD_INFO
WHERE
    UPPER(ZONE_HEAD_NAME) LIKE upper('%Ami%'); -- used upper case AMI here

Cheers!!