> > > > 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.

then you are probably not using the exact search string (including XML)
Alan