Or maybe not. Any smart way to make something like this work? Maybe I just don't see it.
SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), CAST(x'0001' as blob sub_type binary)) FROM rdb$database The `CAST(1 AS SMALLINT)` is, at the moment constant byte value I'm getting (hence I could generate x'...' literal), but it can be i.e. column (and hence the literal approach would not work). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel