Thanks Mark.
On 2018-03-09 06:33, hugo.lar...@yahoo.com [firebird-support] wrote:
> I have a column char(2) where two ASCII values stored. For example
> 0011, 0001 are stored as (3,1).
> When I do a select I dont get any result because the result is not
> alphanumeric. 3 is ETX and 1 is NUL.
> I can
Many thanks András!
//ugo
Hi Hugo!
If i understood well, you need this (tested on Fb2.5.8):
select * from table where field = ascii_char(3) || ascii_char(1);
or
select * from table where ascii_val(substring(field from 1 for 1) = 3 and
ascii_val(substring(field from 2 for 1) = 1;
András
From: