I did this for abstract of stories published by using Left(story,200). Pete Lundrigan Media Resources Center Academic Web Support 316.978.7759 http://www.mrc.twsu.edu/ [EMAIL PROTECTED]
-----Original Message----- From: Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 5: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]
