«

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

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/ASPInsider
http://aspnet101.com
http://iWritePro.com



<> wrote in message
news: ups.com...
> 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
>

On Jun 20, 1:06 pm, "David Wier" <davidw...@davidwier.nospam.com>
wrote:
> 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
>
> <bba...@yahoo.com> wrote in message
>
> news: ups.com...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

I am using GridView datasource.