Hi there, I've got a column which contains hex data in string format. I run the following query:
select conv([column], 16, 10) from [table] limit 5; The output, though, seems to mess up if two or more consecutive columns contain the same data. To test this out I did: select conv("a", 16, 10) from [table] limit 5; In theory (unless I'm mistaken) this should produce five rows with "10". Instead, it produces: OK 10 794 15002 3441418 913786650 Time taken: 17.235 seconds Can you offer me any suggestions? Thanks, Annie Graebner Return Path