select only 100 char display description in sql

select only 100 char display description in sql

//Select

   Select  Content From  Char_Index

//Select Only 50 Char

  Select Left(Content,50) as Content From  Char_Index