Change your v_string = line to
Code:
v_String := p_Param || '%';
If you use quotes in the actual column content then just remove the last set of quotes on the v_string definition.

At the moment you searching for something like 'A_Word%' what you should be searching for is A_Word%

Regards