You will have to use SUBSTRING function
declare @tmp table (data varchar(500))
insert into @tmp values('Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to disable or prevent resize of HTML TextArea in browsers like Google Chrome, Mozilla FireFox and Apple Safari using CSS3')
select substring(data, 0, 50) from @tmp