>>>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))