Hi all, can anyone tell me what I am missing here. Using CR2011 and needed to create the following command. Tested piece by piece and command works until I get to the final "TaskNote"."NoteText" I get the error "the text, ntext and image data types cannot be compared or sorted, except when using IS NULL or LIKE - does anyone know how to get around this, because i need that text field in my cammand.
SELECT "TaskNote"."WOID",Count( "TaskNote"."TaskNoteId") AS 'CountNotes', "TaskNote"."TaskNoteTypeId" AS 'TypeId',"TaskNote"."TaskNoteCategoryId" AS 'CatId',"TaskNote"."CreateDate" AS 'Date',"TaskNote"."CreatedBy" AS 'Tech',"TaskNote"."NoteText" AS 'Note'
FROM "TRACKIT_DATA"."dbo"."TaskNote"
WHERE "TaskNote"."TaskNoteTypeId"=2
GROUP BY "TaskNote"."WOID","TaskNote"."TaskNoteTypeId","TaskNote"."TaskNoteCategoryId","TaskNote"."CreateDate","TaskNote"."CreatedBy","TaskNote"."NoteText
SELECT "TaskNote"."WOID",Count( "TaskNote"."TaskNoteId") AS 'CountNotes', "TaskNote"."TaskNoteTypeId" AS 'TypeId',"TaskNote"."TaskNoteCategoryId" AS 'CatId',"TaskNote"."CreateDate" AS 'Date',"TaskNote"."CreatedBy" AS 'Tech',"TaskNote"."NoteText" AS 'Note'
FROM "TRACKIT_DATA"."dbo"."TaskNote"
WHERE "TaskNote"."TaskNoteTypeId"=2
GROUP BY "TaskNote"."WOID","TaskNote"."TaskNoteTypeId","TaskNote"."TaskNoteCategoryId","TaskNote"."CreateDate","TaskNote"."CreatedBy","TaskNote"."NoteText