To specify a LOB in a search condition, do one of the following:
- Cast the LOB to a non-LOB type (for example, cast BLOB to BYTE or VARBYTE, cast CLOB to CHARACTER or VARCHAR)
- Pass the LOB to a function whose result is not a LOB.