One reason for not returning any data could be if the column is case sensitive. You can try the following
SELECT pxp.invoice,
p2.bookingRef
FROM pxp,
PolarCruiseBrandPaxFile2 p2
WHERE pxp.invoice COLLATE UTF8_GENERAL_CI LIKE '%' + p2.bookingRef + '%';