Re: [sqlite] query help with inline conversion of hex data

2012-04-18 Thread Jim Sanders
t 5:47 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 18/04/12 14:39, Jim Sanders wrote: > > I found that, but I need essentially the reverse of that. The data > > stored in SQL is 3061626364 and I need to convert it back to 0abcd > >

Re: [sqlite] query help with inline conversion of hex data

2012-04-18 Thread Jim Sanders
I found that, but I need essentially the reverse of that. The data stored in SQL is 3061626364 and I need to convert it back to 0abcd (from your example) On Wed, Apr 18, 2012 at 5:35 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 18/04/12 14:30,

[sqlite] query help with inline conversion of hex data

2012-04-18 Thread Jim Sanders
;'') Unfortunately, I don't have the ability to just grab the raw data out of SQL and then post-process it with PHP or another language for this specific task (which would be much easier for me). I'm trying to keep this as a built-in report for Spiceworks, and that limits m