Selecting fixed amount of characters from a "memo" fieldin an access database

[Tomdogggg]

How would I do this? I don't care but preferably I would like to accomplish
this IN the query. But probably it will have to be done after the data has
come back. In that case, I would like to have a "..." placed after those 100
characters, is it possible? If so, how do I do it?

Thanks Thanks,
Tom

[cf_montare]

I'm pretty sure Access has a standard 'left' function like most databases...

<cfquery...>
select left(myMemoColumn, 100) as mySummary
from...
</cfquery>

[Tomdogggg]

Thanks for the help, I'm only about 6 months into coldfusion developing. A lot
of times, the biggest challenge is knowing when certain functions exist and
when you have to try to figure it out on your own.

[Mountain Lover]

If you have Access installed C:\Program Files\Microsoft
Office\Office\1033\JETSQL40.CHM gives you the Access JetSQL reference
The VB help comes in handy once in awhile as well!
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]