Subject Re: [firebird-support] How to query for a GUID value that is stored as OCTETS?
Author Ann W. Harrison

> Before I was storing the GUID as a simple char(36). Obviously I have
> somehow to convert the GUID into a CHAR(16) with the charset OCTETS.

I suggest you find (or write) a udf that takes a char(36) string and
converts it to a char(16) OCTETS hex value. Then the the where clause
is "where GUID_FIELD = myConvertFunction(<string>);"