Hi, I would like to use VB to access a field in MS Access db which contains an article but I only want to retrieve a select sample from each article not the whole article. Any ideas Thanks Richard

You can specify the size of data thast you need to retrive in the Sql squery.

what would be an example of an SQL query that would enable me to retrieve just an extract from an article just like occurs in GOOGLE when you type in a word in the search box. Thanks Richard