Convert hex to string

[HomerJS]

I have a value that I need to convert to a hex number, take off the leading Fs, and then use the rest to retrieve a file.

Example:
value: -2144747826

hex value: FFFFFFFF8029BECE

file name: 8029BECE

The way I have it set up so far is I have the hex value in a SQL database with the varbinary datatype. However I can't convert that to a string value so I can use it as a file name.

Any suggestions would be appreciated.

Thanks!

 

[shatch]

Here you go:

Dim intInput As Long = -2144747826
Dim strHex As String = Hex(intInput)
MsgBox(strHex.TrimStart("F"))