- Many unique indentifier IDs are defined in Prowatch as varBinary(18) data type. And values in these columns should be converted into readable number such as int, bigInt or string.
- Converting them from ‘Varbinary’ into ‘Int’ data type, the result shows duplicated values. It is not working.
- Converting into ‘BigInt’, values show 18 digits which is too big.
Need help on how do we do this conversion to Int data type or String without any issues