Yes, if you want to create index on it. In SQL select 254 works just fine.
>Hi!
>
>Is not it should be 240? (max length of VFP index key)?
>
>>John,
>>
>>Add PADR(mymemo, 254) AS sortoder and ORDER BY sortorder to your SELECT.
>>
>>> How could I ORDER MEMO FIELD in SQL statement? I get error ORDER BY invalid clause error. I tried to include my memo field in my select list, but it still the same. Any ideas?
>>>
>>>Thank you
--sb--