Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[DWMX/ASP] Truncate some database output 1

Status
Not open for further replies.

uridium

Programmer
Apr 4, 2001
27
GB
Hi,

I'm building a search results page.

I want to show the content of each search result, but I want to truncate it to the first 100 characters or so. In the example below, I would want the red bit truncated to 100 chars.

<li>
<%=(SearchResults.Fields.Item(&quot;entry_heading&quot;).Value)%>
<br/>
<%=(SearchResults.Fields.Item(&quot;entry_content&quot;).Value)%>...
</li>

Any ideas how to do this?

(If its been answered already feel free to point me at the thread in question :) )

--
Olly
 
<%=LEFT(SearchResults.Fields.Item(&quot;entry_content&quot;).Value).Value,100)%>

> need more info?
:: don't click HERE ::
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top