>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.
If it's not broken, fix it until it is.
My Blog