Maximum character in result in SQL Server 2000

• prateek.one4u

  Grasshopper

  Points: 10

  More actions

  February 20, 2009 at 12:39 am

  #206189

  I have a column with text data type in a table. I am trying yo view the content of that column but the result is getting truncated to only 8192 character. Is there anyway to increase this limit or to view the whole value of this column ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  February 20, 2009 at 9:18 am

  #947610

  How are you viewing this? Some apps might limit it there. TEXT should bring back the full value unless you are CASTing it somehow.