Select Statement

[bbawa1]

Hi,

I have the following query. my message field is of datatype text.
But I want to grag just first 50 characters + ...
from that "message" field. How can I do that.

The following is my sql statement

select tck.ticketid,tckmsg.message
from tbtickets tck inner join tbticketsmessages tckmsg
on tck.ticketid = tckmsg.ticketid and tcktstatusId = 1

 

[David Wier]

if you want to do it in SQL, check out 'substring':
http://doc.ddart.net/mssql/sql70/setu-sus_17.htm

when presenting the data on the page, are you using a Gridview/DataSource
control, or creating the code- then databinding, or .....?

 

[bbawa1]

if you want to do it in SQL, check out 'substring':http://doc.ddart.net/mssql/sql70/setu-sus_17.htm

when presenting the data on the page, are you using a Gridview/DataSource
control, or creating the code- then databinding, or .....?

--
David Wier
MVP/ASPInsiderhttp://aspnet101.comhttp://iWritePro.com









- Show quoted text -

I am using GridView datasource.