• The reason I don't use ntext is that you can't define local variables with that type. I have some pretty complex stored procedures and I need the flexibility of local variables.