>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.
VARCHAR(MAX) or NVARCHAR(MAX)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges