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 .....?

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

<bb****@yahoo.comwrote in message
news:11**********************@e9g2000prf.googlegro 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

[bbawa1]

On Jun 20, 1:06 pm, "David Wier" <[e-mail]>
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

<[e-mail] in message

news:11**********************@e9g2000prf.googlegro 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.