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 |
|
kenchee
Starting Member
49 Posts |
 Posted - 2007-09-18 : 19:57:25
|
| Hi, can someone show me how to convert a hex string (varchar(13))eg. '44708AFE0003' to an integer and then back to hex string. I am trying to insert records into a table that has a hex string as it's primary key. that is why i need to convert the hex string to an integer and then increment it by 1 then convert it back to hex string and insert the record.Table example.----------------------pk------------44708AFD001444708AFD001544708AFD001644708AFD001744708AFD0018thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-09-18 : 23:02:26
|
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-convert-hex-string-to-varbinary.aspxhint: google is your friend.
elsasoft.org |
 |
|
|
|
|
|
Hex String to Int And Back