>I do a Select-SQL to query data from different tables and put it in a cursor to show in a listbox. My problem is if one field is a Memo field and should be shown in the listbox it just writes out Memo instead of the first characters from the memo.
>
>I've tried to do like this with the select but it's not possible:
>
>select substr(memofield, 1, 30)....
>
>Is there any easy way to do a select-sql and show a memo-field in the listbox?
>
>Thanks in prior!
>
>/Mårten

You can use Select Left(memofield,10)... I don't know what's happened with SUBSTR(), but it really generates error (bug?).