I have a SELECT statement in a program that is using a LIKE conditional. A program converted our Access text fields into BLOb fields in the Oracle DB, but the BLOb field doesn't like the LIKE operation.

I was looking at some documenation and was wondering if NCLOb would work. If not, any other ideas?