bpowers
SSCertifiable
Points: 5483
More actions
June 15, 2009 at 10:42 am
#155831
I have the following update I would like to perform, however the column I am updating (BITS) is an image type. How can I accomplish this?
UPDATE PART_PO_BINARY SET BITS = '1, 2, 3' WHERE PART_ID = '1133500-1'
Steve Jones - SSC Editor
SSC Guru
Points: 736494
June 15, 2009 at 10:47 am
#1009774
Use UPDATETEXT (http://msdn.microsoft.com/en-us/library/ms189466.aspx), however if your data isn't larger than 8k most of the time, you shouldn't be using image. Go with varchar instead.
June 15, 2009 at 12:42 pm
#1009851
That works. Thanks for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply