Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
triumph
Starting Member
3 Posts |
 Posted - 2007-02-26 : 04:59:41
|
| Hi , I am running into this error message on SQL server 2000 ."The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."I get this error when i execute a simple update statement .UPDATE TableName SET Field_ONE=?, Field_TWO=? WHERE Field_THREE=? AND Field_FOUR=? I am not sure why i am getting this error message . I looked up for some info , on the net but its not helping .thank youkishore |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
|
|
triumph
Starting Member
3 Posts |
Posted - 2007-02-26 : 05:24:25
|
| Interestingly i am using only varchar and nvarchar , i do not have any text or image or ntext datatypes. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-26 : 05:29:55
|
quote:
Originally posted by triumph
Interestingly i am using only varchar and nvarchar , i do not have any text or image or ntext datatypes.
please post your table structure ?
KH |
|
|
|
triumph
Starting Member
3 Posts |
Posted - 2007-02-26 : 05:35:04
|
| sorry abt my earlier post , one of the field being updated is an image .i will look into the link and update . |
|
|
|
|
|
|
|
|
SQL error message :The text, ntext, and image data