I'm pretty sure you can just use LEFT(), but I haven't done many Queries in Access lately.
Chris Tifer ----- Original Message ----- From: "Scott" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 3:34 AM 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]
