Chuck Roberts <croberts@gilsongraphics.com> writes:
> I think this might be a data problem. If anyone else has an idea, it's
> welcome.
Well, the obvious question is, are you sure you have records that *should*
match the condition?
Plain "trim" is not very bright, it will only remove characters that are
plain ASCII spaces. I'm wondering a bit about whether there's carriage
returns, tabs, non-breaking spaces, or other weird kinds of whitespace in
your data, which might make it so records that look like they contain
"540" don't actually match.
regards, tom lane