SELECT Leads.leadid, Leads.leadname, Leads.phone, Leads.admissrepid,; Leads.resolution,; IIF(ISNULL(Enroll.enrollid),0,Enroll.enrollid) AS enrollid,; IIF(ISNULL(Lookuplist.entry),SPACE(20),Lookuplist.entry) AS entry; FROM ; smagic!leads ; LEFT OUTER JOIN smagic!enroll ; ON Leads.leadid = Enroll.leadid ; LEFT OUTER JOIN smagic!lookuplist ; ON Leads.resolution = Lookuplist.lookupid; WHERE UPPER(Leads.leadname) = UPPER(?vp_leadname); AND Leads.phone = ( ?vp_phone )Both parameters are character. All values for vp_phone work correctly. When vp_leadname is given a value that would return only one record, it throws the error. A blank vp_leadname or one that returns several records works properly.