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 john
You're out of luck. 8,000 is the max for varchar. Would it help to split into two or more varchar variables? Frank http://www.insidesql.de http://www.familienzirkus.de
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 Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
