Hexvalue in trigger or procedure

[rvdw]

Is there somewhow the possibility to convert an integer to a hex value , similar to the hex() function in VB ? I want to create a trigger that gives each record a rowid, and part of this rowid is the hex. representation of an integer.
At this moment people who want to upload data have to use a vb routine, so i want to replace this by a trigger or procedure alike ...
any help is welcome...
Tks,
rov

[MAK]

here we go

select convert(timestamp,123)
select convert(timestamp,1)


------------
rvdw at 5/27/2002 4:08:25 PM


Is there somewhow the possibility to convert an integer to a hex value , similar to the hex() function in VB ? I want to create a trigger that gives each record a rowid, and part of this rowid is the hex. representation of an integer.
At this moment people who want to upload data have to use a vb routine, so i want to replace this by a trigger or procedure alike ...
any help is welcome...
Tks,
rov