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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2007-06-20 : 16:32:46
|
| Hello,I have a table FirstName(varchar), LastName(varchar),Picture(Image)Picture has a defualt (0xffd8ffe000104a46494600010201004800480000ffed1bca50686f746f73686f7020332e30003842494d03ed000000000010004800000001000100480000000100013842494d040d000000000004000000783842494d03f300000000000800000000000000003842494d040a00000000000100003842494d27100000000000)If default is stored there is no picture. I want to find out who has no picture but I can't search onSelect * from tablename where picture = '(0xffd8ffe000104a46494600010201004800480000ffed1bca50686f746f73686f7020332e30003842494d03ed000000000010004800000001000100480000000100013842494d040d000000000004000000783842494d03f300000000000800000000000000003842494d040a00000000000100003842494d27100000000000)'The returned error: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.Is there any way to do this with Image files?Thanks in advance for your help.R/ P |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2007-06-21 : 13:47:17
|
I think I've given up.I've searched and can find nothing (that I can understand) that helps me. P |
 |
|
|
|
|
|
Image File