Thanks again chris
you pointed me in the right direction and i cobbled together different examples and it now works.
Was scratching my head for awhile when the resultset was coming back with nothing.
Then realised was so focused on the prepared statement had forgotten the wildcard.
Then had lots of problems trying to get % to work, tried it everywhere (i thought) and nothing worked.
so typed problem into search engine and this sorted that out
stackoverflow - using wildcard in prepared statements
This seems to work fine