I need to search for records with instances of a specific word or phrase ( 'searchtext') in a particular sql db field. However, the contents of this field is often pretty big (2000 chrs or more), so if I just do a %like% search I'm quite likely to get a pretty hefty recordset return. All I want for each instance of a match is to get the 50 or so characters each side of the match, so I can see the context of the match. Is there any way I can do that in the query itself?<BR><BR>existing query:<BR>sql = "SELECT ID_N,newsletter_date FROM [newsletter_contents]<BR>WHERE description_ LIKE '%" & searchtext & "%' <BR>ORDER BY newsletter_date asc"<BR><BR>I've tried searching the faqs etc but no joy. Any help gratefully appreciated?!