>Hi,
>
>I think I have known this (or asked this before) but forgot (sorry). How do I cast an empty string into a memo type column when sending SQL Select to SQL Server? For example, in VFP I would do it like the following:
>
>

>select *, cast( '' as MEMO) As MyMemoFld from MyTable
>

>
>What should be in place of MEMO in the case of SQL Server? TIA.

Everything with length bigger than 255 will be converted to memo:

select *,
       cast( '' as varchar(256)) As MyMemoFld
from MyTable

----
select *,
       cast( '' as varchar(max)) As MyMemoFld
from MyTable