Select Returs Truncated Text Data...

Hello,

I have a table with the following structure for which I execute a SELECT statment against to retrieve the value of a particular NoteText field. Every time I execute the select the Notes are truncated in the returned recordset and I cannot get it to return the full value. I have tried various options, Cast/Convert, Set TEXTSIZE, etc but to no avail. Advice?

CREATE TABLE [dbo].[SOOrderNote_T] (
[SOOrderNote_TSK] [int] NOT NULL ,
[SOOrder_TSK] [int] NOT NULL ,
[PXNoteTypeSK] [int] NOT NULL ,
[NoteText] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

--My Select which returns truncated notes
Select NoteText From SOOrderNote_T where SOOrder_TSK = XYZ

Thanks in advance!