varcar | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


How to assign a variable which will accept more than 8,000 characters(I need unlimited) with varcar function. It should take exact space though the option is unlimited like varcar. Thanks

You’re out of luck. 8,000 is the max for varchar.
Would it help to split into two or more varchar variables? Frank
If not consider TEXT datatype or TABLE datatype to work as a variable in the database.
REfer to books online for more information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.