Hi there,

I have a column which is byte(32375), my understanding is it is a blob with binary data. Since it only contains large text, my question is can I get a sub string of this column?

Thanks,
Jinse

BLOB columns require special
handling and so can only be handled in ESQL/C, ODBC, or 4GL programs which
means that you cannot display a BLOB in dbaccess, perform, or ace. You
also cannot include a BLOB in a where clause except as a substring
expression.

blobtable (one text)
in dbaccess:
select one[1,4] from blobtable
----------------------------------------------
one
Ahoj
-------------------------------------------
blobtable1(one byte)
in dbaccess:
select one[1,4] from blobtable1
------------------------------------------
one <BYTE value>
------------------------------------------

So it look like you can get a substring of you column whe you change it from
byte to text ( TEXT and BYTE are actually
treated the same by the engine)