Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with 'like' compare
On Sat, 24 Jul 2004 13:42:50 -0400, ohaya <ohaya_at_cox.net> wrote:
>there's something like:
>
>"....SerialNumber: [0a]..."
No space after the [.
>
>My SELECT looks something like:
>
>SELECT * from mytablename where lower(myfield) like
>lower('%serialnumber: [ 0a]%')
^
A space after the [. They don't match.
-- Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/spaceReceived on Sat Jul 24 2004 - 12:57:28 CDT