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

• Next in forum: Re: Can i debug/watch on the trigger's INSERTED and DELETED records/values?
• Prev in forum: Re: Query out an xml element from a field containing xml data
• Thread view: Re: select cast help needed

[Reply to this message]