I have the following: WITH RECURSIVE expansion(byte) AS ( SELECT 0 UNION ALL SELECT byte + 1 FROM expansion LIMIT 10 ) SELECT hex(byte) FROM expansion ;
?I would expect to get 00-09, but I get 30-39. 30 is the hex-value of the ASCII 0. How would I get what I want. I could subtract 48, but that is not my preferred solution.? -- Cecil Westerhof