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 |
|
semesta
Starting Member
3 Posts |
 Posted - 2010-05-27 : 05:00:08
|
| hi there,I wanna change value in binary field, how to do that? the message said that I have to use CONVERT function. please help me, since I never use this function and I'm beginner with ms sql. thanks a lot. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-27 : 05:04:59
|
Can you show us the statement that brings up the message and the table structure to see the data types?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
semesta
Starting Member
3 Posts |
Posted - 2010-05-31 : 03:51:08
|
| sorry i made mistake. I should not use ' while enter data. thanks. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-31 : 05:13:09
|
| Yes. Otherwise they would become varchar valuesMadhivananFailing to plan is Planning to fail |
|
|
|
semesta
Starting Member
3 Posts |
Posted - 2010-06-02 : 00:32:14
|
| then, how to convert from varchar to binary, use update command? thanks before.if I need to make new post, then please let me know. thanks before. |
|
|
|
|
|
|
ask - input binary