Title = objRS("Title")<BR>Title = left(Title,55)<BR> if mid(Title,55) <> "" then<BR> Title = left(Title,55) & "..."<BR> end if<BR><BR>i dont know if there is a way to do it straight from a select, but this is what i do to crop the text into a certain length to fit into table cells, and what not. is that what you were looking for?
Yip I think that is what I was looking for. I want to only show so many words/letters in a table cell. I am displaying top ten posts in a right sidemenu and don't want long headings there.<BR><BR>Thanks for you help<BR><BR>Stephen