Mehrdad wrote:Your code should say:
I am trying to pass a parameter to a function that is using the LIKE '%name_in%',
I don't know how to use it...
the parameter is called 'name_in'
If name_in is inside single-quotes, it will mean the 7 literal characters 'n', 'a', 'm', 'e', '_', 'i' and 'n'.
... LIKE '%' || name_in || '%'