HEX in varchar to int or bigint conversion
Posted on 2003-10-22
Im desperately trying to convert a hex value into either an int or big int.
The snag is that the hex number is bulk inserted and the sourcefile does not stipulate 0x infront of the number so bulk insert blows up if i use varbinary to import the field.
Thus im bulk inserting the 10 million+ records into a varchar field, I then need to convert this to int.
I cant afford any form of cursors or string manupulation to do this. because the operation nees to complete within a few seconds.
In short.... I want to be able to convert to an integer a hex value stored in a varchar where the varchar looks something like this: