How do I get by with "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

• hbanerje

  SSC Eights!

  Points: 818

  More actions

  May 24, 2012 at 11:04 am

  #257030

  select ID_NUM as ID_num, LAME1, RESP_CODE as RESP_CODE1,cast(QUERY_COMM as nvarchar(max)) as QUERY_COMM1

  from dbo.DRGQueries

  group by ID_NUM, LAME, RESP_CODE,QUERY_COMM

  having COUNT(*) >1

  where I have Query_comm as ntext as datatype and

  Resp_code nvarchar(50) in the above table.

  I am getting the error message

  "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

  Thanks,

  Haimanti

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 24, 2012 at 11:07 am

  #1492694

  Like this (you were half way there).

  select

  ID_NUM as ID_num,

  LAME1,

  RESP_CODE as RESP_CODE1,

  cast(QUERY_COMM as nvarchar(max)) as QUERY_COMM1

  from

  dbo.DRGQueries

  group by

  ID_NUM,

  LAME,

  RESP_CODE,

  cast(QUERY_COMM as nvarchar(max))

  having

  COUNT(*) > 1;

• hbanerje

  SSC Eights!

  Points: 818

  More actions

  May 24, 2012 at 11:57 am

  #1492707

  Thanks so much!