automatic cast from a text field to a varchar?

• davidm732

  Grasshopper

  Points: 10

  More actions

  June 23, 2008 at 10:11 am

  #183703

  SELECT OPOR.DocNum AS 'Style No.',INV10.LineText,

  max(case when ITM1.PriceList=1 then ITM1.Price end) as 'First Cost'

  FROM OPOR, INV10, ITM1

  GROUP BY OPOR.DocNum,INV10.LineText, ITM1.Price

  this is my code..

  i get the error: "The text, ntext, image data types cannot be compared or sorted, ecept when using IS NULL or LIKE Operator"

  how can i cast LineText to make this code work? (i do not know the lenght)

  Any help is appreciated..Thanks

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 23, 2008 at 11:14 am

  #832922

  use:

  cast ( field as varchar(max) )

  
  * Noel

• davidm732

  Grasshopper

  Points: 10

  More actions

  June 23, 2008 at 11:48 am

  #832949

  thank you