If you don't know the entire name or the exact case you will need to use UPPER and LIKE instead of =
SELECT custName, custId from customer where custIntroducerName = 'myNameToFind'
Mark this question ANSWERED. If you need more help post in the correct forum.
SELECT custName, custId from customer where UPPER(custIntroducerName) LIKE '%MYNAMETOFIND%'