Post reply

Error

  • November 4, 2005 at 11:12 am

    #188249

    can any one tell me what does this error means

    error 306:The text,ntext, and image types cannot be compared or sorted,except when using ISNULL or LIKE

  • November 4, 2005 at 12:01 pm

    #602422

    Can I compare a text field in WHERE clause.

  • November 4, 2005 at 12:12 pm

    #602426

    The error you are getting is pretty self explanatory. The only valid operators that you can use for text fileds on the "where" clause are "LIKE" and "IS NULL"

    ex:

    select * from mytable where textColumn like 'word%'

    or

    select * from  mytable where textColumn IS NOT NULL

     

    Cheers,

     


    * Noel

  • November 4, 2005 at 12:31 pm

    #602431

    Ok thanks a lot for ur reply.

  • November 4, 2005 at 12:34 pm

    #602434

    Happy to help


    * Noel

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply