>>>>Hi again, all
>>>>
>>>>I have some fields in my SQL table defined as nvarchar(max), mostly because I have no idea how long the string might be. Unfortunately, when I pull a record back they come across as a Memo field, which I don't really need.
>>>>
>>>>Is there any way to stop this behavior? Bad SQL! no SQL cookies!
>>>
>>>You can select LEFT(nvarcharColumn, 250) to make it a character.
>>
>>Still returns a memo
>
>Try
>cast(nvarcharCol as varchar(240))
That worked, thanks