Query to search for a given string(Code) in Peoplesoft People code

SELECT * FROM PSPCMTXT WHERE PCTEXT LIKE '%code xyz%' AND PCTEXT LIKE  '%code xyz%'