Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    2

    Unanswered: How to determine largest memo field

    How can I determine the largest memo field, that is, the number of characters in the largest record? I want to change a memo field to a text field, but not lose any data, so need to know the number of characters in the largest record. If I can find the actual record with the most information that's a bonus but not required.

    Thanks,
    Brian

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    run this query against your table

    SELECT tblData.MemoField, Len([MemoField]) AS CountChar
    FROM tblData
    ORDER BY Len([MemoField]) DESC;

    where: MemoField is the memo field whose characters you want to count
    tblData is the table that contains the Memo field

    Hope this helps.....

  3. #3
    Join Date
    Mar 2002
    Posts
    2

    Home Run

    Perfect. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •