returning value from column having ampersand

[slam]

Hello,

This should do the trick

select contact
from tablename
where company like '%'||chr(38)||'%';

Kind regards,

SLAM