Student Search In Calista
SELECT PERSON_ID, TITLE, PREFERRED_GIVEN_NAME, SURNAME, GIVEN_NAMES, SEX, EMAIL_ADDR, STAFF_MEMBER_IND, STUDENT_IND
FROM SIS_OWNER.PERSON_DISPLAY_V
WHERE (PREFERRED_GIVEN_NAME LIKE '%' || :Search || '%') OR
(SURNAME LIKE '%' || :Search || '%') OR
(GIVEN_NAMES LIKE '%' || :Search || '%')
ORDER BY SURNAME, PREFERRED_GIVEN_NAME