select left(campo,5) as primi_5 from tabella

oppure

select substring(campo,1,5) as primi_5 from tabella