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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-11 : 16:42:18
|
emanuele ferro writes "I have a table with a column of integers values, named USERID. I want update this same column with hex(USERID) but using the hexadecimal number like a decimal one.
For example, if USERID=56, I want update this field with hex(56) = 38. Obviously, 38 is intended to be a decimal number (without other conversion).
I'm using SQLServer 7, NT 4.0, SP 6.
Thanks in advance.
Emanuele Ferro" |
|
|
|
|
|
decimal to hexadecimal conversion