--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@>
> > wrote:
> > >
> > > >
> > > > Is there a way to change a blob field from sub_type 1 to sub_type 0
> > > > without losing the data in the column? I have tried alter table
> > alter
> > > > column but the engine is not letting me change it. Perhaps I can
> > > > modify some system tables?
> > > >
> > > >
> > >
> > > don't do a system table mod
> > > create a new field, update the new from old then drop the old.
> > > If you want the same name, then do it again with the original field
> > name
> > > ALan
> > >
> >
> > ok, tried that. turns out the problem I am trying to fix remains. I
> > have the contents of an XML file in this blob field. When I am viewing
> > the contents through SQLHammer or even issuing SQL against the field
> > doing a "Blob field like '%SomeValue%'" I am not getting any results.
> > I know however that "SomeValue" is contained within the XML file.
> >
> > Any ideas?
>
> try CONTAINING
>
> Alan
>

Sorry. Didn't work.