Upper, Longvarchar and RTF text

Hi!

I have this: select * from blaaah and upper(somefield) like '%EPLACED %'

somefield is of type LongVarchar, and contains text in RTF format. We are looking for the text "Replaced", which in most cases is "R\f1 eplaced".

The upper should help us out, for both "upper" and "like" I get an errors: expexted NUMBER got LONG.
It is a longvarchar.
Even select upper( the field) will cause that problem.

The text looks like eg:
{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil
\fcharset186{\*\fname Arial;}Arial Baltic;}{\f2\fnil Arial;}}
\viewkind4\uc1\pard\lang1061\b\fs20 R\f1 EPLACED WITH ITEM xxxxxxx
\f2
\par }

Any ideas to overcome this?

BR
Sonnich Received on Tue Jun 12 2007 - 04:56:51 CDT