oracle8.1.6 select to_char(ese.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi, nvl(person.name(ese.modifying_user),person.name(ese.creation_user)) as modifying_user, ese.modifying_ip, ese.description as comments, ese.grade as task_grade, case when content_revision.is_live(ese.evaluation_id) = 't' then 1 else 0 end as is_live from evaluation_student_evalsx ese, evaluation_tasks et where ese.task_item_id = :task_item_id and ese.party_id = :party_id and et.task_item_id = ese.task_item_id and content_revision.is_live(et.task_id) = 't' $orderby