How can I retrieve data from text datatype column from a table?

• alien

  SSC Veteran

  Points: 280

  More actions

  October 5, 2007 at 10:59 am

  #182496

  Hi,

  I have a table which has two columns.The first column's data type is text.I need a query to fetch the value of the column using SQL Query analyser.I am using SQL Server 2000.Please help me.

  Thanks in Advance,

  Swati

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  October 5, 2007 at 11:39 am

  #739652

  Please repost over in the 2000 forum to get 2000 specific help.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning