SELECT *,SUBSTRING(campo,0,50) as 50_lettere FROM tabella