You're welcome.

>
>You are a star - many thanks for that pointer.
>
>To get this to work properly you must add an option to the end of the connection string.
>
>lnHandle = SQLSTRINGCONNECT("driver=dvrname;server=srvname;uid=user;pwd=passwd;option=134217728;")
>
>Now the returned table has a memo field for the Longtext data.
>