Código SQL [-] select coalesce(substring(nombrepaciente from 1 for 80), diagnostico) from recetas
select coalesce(substring(nombrepaciente from 1 for 80), diagnostico) from recetas