Re: [sqlite] built in function hex

2007-10-08 Thread Andy Goth
On Mon, 8 Oct 2007 10:03:40 -0700 (PDT), Ken wrote > is there a built in function to display numeric values as > hexidecimal strings? to_hexstr (40) would display 0x28 hex() isn't quite what you want. hex(40) gives 3430, since '4' is 0x34 and '0' is 0x30. Moving on... This is the sort of

[sqlite] built in function hex

2007-10-08 Thread Ken
is there a built in function to display numeric values as hexidecibmal strings? to_hexstr (40)would display 0x28 Thanks, Ken