Text Preview in ASP

What is the best way to display so many characters of text on a search results
page? Let's say 200 characters. If I add the dynamic text to my asp page for
the description it shows all the text in the database, but I want to limit the
text displayed from the recordsets dynamic text so users can preview the
description.

Example:

I search for german shepherd and on the results page I see:

German Shepherd
The first impression of a good German Shepherd Dog is that of a strong, agile,
well muscled animal, alert and full of life. It is well balanced...


Thanks.

If you want say the first 200 characters of a field, you would have this in
the SQL of your recordset:

SELECT LEFT(fieldname,200) AS Description

and then use Description as the field you drop on the page where you want
the display.


--
Nancy Gill
Team Macromedia Member: Dreamweaver MX/UltraDev
http://www.macromedia.com/go/team/
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"_Mike" <webforumsuser (AT) macromedia (DOT) com> wrote

What is the best way to display so many characters of text on a search
results
page? Let's say 200 characters. If I add the dynamic text to my asp page
for
the description it shows all the text in the database, but I want to limit
the
text displayed from the recordsets dynamic text so users can preview the
description.

Example:

I search for german shepherd and on the results page I see:

German Shepherd
The first impression of a good German Shepherd Dog is that of a strong,
agile,
well muscled animal, alert and full of life. It is well balanced...


Thanks.

That worked. Thanks for your help Nancy.

Mike