Text vs. Memo

Results 1 to 3 of 3

Thread: Text vs. Memo

  1. #1
    Join Date
    Dec 1969

    Default Text vs. Memo

    I am currently using a access data base and asp to create a web product procurement site. I have declared Account_Name as a text memo field in the data base but am now unable to order or sort the information in that field. field type text is simply too small for what I am doing. Is there another solution that I am missing?

  2. #2
    Join Date
    Dec 1969

    Default RE: Text vs. Memo

    You can&#039t use a Memo field for sorting/ordering in many DB systems. The reason is simple: It&#039s too darned much data and it would slow down processing too much. <BR><BR>What is the likelihood that if two fields don&#039t manage to be different somewhere within the first 255 characters that they will be different at the 256th? Or at the 3,112,673rd?<BR><BR>So if you really need to sort on the first 255 characters of your memo field, why not move the first 255 characters of each memo field in each record into a TEXT field and sort on that? Then, when you *use* the record, you can past the remaining characters back onto the end of the 255 characters.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Another? Solution

    A variation on the same theme.<BR><BR>Instead of a separate field, just use the first 255 chars of the memo field by use of Mid Function.<BR><BR>Viz<BR><BR>SELECT Mid([MemoFieldName],1,255) AS Expr1, OtherField<BR>FROM YourTableName<BR>ORDER BY Mid([MemoFieldName],1,255);<BR><BR>R

Posting Permissions

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