title: how to deal with Memo fields listed in a SELECT query, in foxpro 9?
body: <p>i have a query where i need to use the DISTINCT keyword, the issue is that a field i have in the select is of type MEMO (needs to be so because of its large content...).</p>
  
  <pre><code>SELECT distinct customerid, commentdate, commenttext....
  </code></pre>
  
  <p>is not accepted in FOXPRO 9 because commenttext field is f type Memo !
  any idea?</p>