The output of the native sqlite function "hex" is not really a hex value of a number. Its a hex representation of a string.
select 5629701397680549, hex(5629701397680549) ; 5629701397680549|35363239373031333937363830353439 Where to_hex outputs: select 5629701397680549, to_hex(5629701397680549) ; 5629701397680549|0x14002f000011a5 [EMAIL PROTECTED] wrote: Mau Liste wrote: > > results in: SQL error: no such function: hex > Added by version 3.3.13, one year ago yesterday. http://www.sqlite.org/releaselog/3_3_13.html What version are you running? -- D. Richard Hipp _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users