I have coded an online program to fetch records from tables. I have used Like in predicates of the SQL, however the SQL is fetching the data only when exact match is found and not fetching other rows.
AND A.Ixxxx_Rxxxx_Nxx = :Gxxxxx-Ixxxx-Rxxxx-Nxx
AND B.Mxxx_Pxxx_Cxx = 'Z'
Say when I am passing Nikesh1 to Gxxxxx-Uxxx-Axxx-Nxx, it is fetching the exact value, but if passing only Nikesh.. then it is not fetching all the rows whose column Uxxx_Axxx_Nxx is starting with Nikesh.
Can you please suggest