Re: SQL "like" operator does not work properly on x$ fixed views

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 14 Aug 2002 15:07:29 +0100
Message-ID: <3d5a6422$0$8505$ed9e5944@reading.news.pipex.net>

"John Findlay" <john_findlay_at_non.agilent.com> wrote in message news:3D5A4656.9020902_at_non.agilent.com...
> An old chestnut. Have a look at the sql reference manual section under
> the 'Operators' heading. It explains LIKE fully. The underscore
> character is a wild card which means 'any single character'.
> So '%_io_%' in your query means exactly the same as '%io%'.

Not quite

%io% will match 'ions' whereas %_io_% won't.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Wed Aug 14 2002 - 09:07:29 CDT