Hi,

If you are sure that a 'text' field will never exceed the 8000 byte varchar limit, are you better served creating varchar fields than text fields? I ask only because they are easier to manipulate than text fields.

What are pros/cons of each? Any "best practice " here? Does answer change if you know field will be less than 4K? <2K?, <1K, etc?

TIA,