The function (for a SQL Statement) is Left (both in MS Access and SQL Server). I presume the articles in the database are stored in Memo fields, in which case your best bet is to use GetChunk to get only the first n characters. If the articles are stored a complete HTML pages, you'll need to do some basic tag parsing in order to remove/interpret the header portion, and strip out or close any open tags in the string that you obtained.
HTH, Tore. -----Original Message----- From: Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 6:35 AM To: ActiveServerPages Subject: Re: ASP Access and Displaying the first Paragraph Alex wrote: : I have an access DB which i have written an ASP front end for. : On my list page i would like to include a "Teaser" being the first paragraph : of what i have in the Synopsis column. : Is this possible and if so how would this goal be accomplished? : Thank you all for your time : Alex Elger I haven't used Access in a veerrrry long time but I would imagine that there is a function that takes the first x characters of a column. In MSSQL, it would be select LTrim(Synopsis, 255) AS Teaser from .... Actually http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/2_005_77.htm hope that helps --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
