Member Avatar for Richard26

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

  • 2 Contributors
  • 2 Replies
  • 83 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by Richard26
Member Avatar for debasisdas

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

Member Avatar for Richard26

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.