I have a table with a column called "hexcode"
The data type in this column is varbinary with a length of 12, and looks like this:
I need to do the following:
I need to extract a substring from the above data to end up with only:
so basically I would like to get rid off the leading: 0x1A000000FCFF12000200
How do I do this?