CURSOR WITH PARAMETER

[Highlander]

This should work:

LIKE ' '%'||v_namesearch||'%' ';