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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-09-03 : 07:16:13
|
| helloi have table containg id, filename and fileinformation fields.fileinformation datatype is image and i store image in binary format in imageinformation field. Due to shortage of sapce i have to set null values in fileinformation filed and keep other field information.i have tried this like thatupdate filetable set fileinformation= '' where fileid=1is this the right way to set NULL in replace of binary data field. Or is there any other best way.thx |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-03 : 07:19:25
|
| '' is not null, it's an empty string, which is different. set fileinformation = null would set it to null.-------Moo. :) |
 |
|
|
|
|
|
set image field to null