The second query

select *

from testdata

where productname like searchpattern escape EscapeClause

is returning to me just one row... I tested the whole code block in the question... care to...