Hi all,
I wish to do something like this
select chr(x'22')
result "
But using a column from a table as the argument
eg
create table test
(
hex_value char(2)
)
insert into test values ('22')
select chr(hex_value) from test; ( I understand this won't work, but I need
something like it )
I have looked at all of the string functions but can't find a solution short
of writing my own function.
We are on 7.2.1
Thanks
Andrew