Posted by Erland Sommarskog on 01/27/06 00:50

T.M. (iamcarterwells@yahoo.com) writes:
> Thank you.
> That works for one field. What if I wanted to get the first 20
> characters from multiple fields? I'm trying to display the first few
> lines of few articles. Each article has its own field in the db. Any
> ideas?

comp.databases.ms-access


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]