4) UNION

select
cursus_code as code,
cursus_descr_nl as descr
from cursustype
where (pk_cursustype = :type)
and (:language = 'nl')
union
select
cursus_code as code,
cursus_descr_en as descr
from cursustype
where (pk_cursustype = :type)
and (:language = 'en')

Christian