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

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

I don't see why I should have to. This works with any other content in the Blob field with the exception of XML.

Here is a snippet from the contents of the XML data in the blob field :

<?xml version="1.0" encoding="UTF-16" ?>
<dta:CSInvoice xmlns:msg="http://Epicor.com/InternalMessage/1.1" xmlns:dta="http://Epicor.com/SC/UserSchema">
<dta:InvcHead>
<dta:InvoiceNum>1239660</dta:InvoiceNum>
<dta:CSConfirmationNum>580459</dta:CSConfirmationNum>

When I search for "580459" using containing, I do not get this record returned, or any for that matter.

If there are no other suggestions, then this sounds like a bug.