Select Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbawa1@yahoo.com - 20 Jun 2007 20:44 GMT

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

Reply to this Message

David Wier - 20 Jun 2007 21:06 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 7 lines]
> from tbtickets tck inner join tbticketsmessages tckmsg
> on tck.ticketid = tckmsg.ticketid and tcktstatusId = 1

Reply to this Message

bbawa1@yahoo.com - 20 Jun 2007 21:20 GMT

> if you want to do it in SQL, check out 'substring':http://doc.ddart.net/mssql/sql70/setu-sus_17.htm
>
[quoted text clipped - 22 lines]
>
> - Show quoted text -

I am using GridView datasource.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...