Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with 'like' compare

Re: Problem with 'like' compare

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 24 Jul 2004 18:57:28 +0100
Message-ID: <7m85g0him4bu0h7f5dto4brmadn514vgj3@4ax.com>


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/space
Received on Sat Jul 24 2004 - 12:57:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US