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

Home -> Community -> Usenet -> c.d.o.tools -> Re: whitespaces in like-clauses?

Re: whitespaces in like-clauses?

From: Rozi & George Goldberger <ghita_at_worldnet.att.net>
Date: Wed, 28 Feb 2001 20:34:56 GMT
Message-ID: <Qhdn6.388$jP.91377@typhoon2.ba-dsg.net>

Hi Stefan,

I tested your SQL and it worked for me. Make sure the number of spaces are exactly as in your where clause format. Any way, this way you will select not only numbers, but any character (string of characters) matching your format.

George

"Stefan Röhle" <roehle_at_mail.uni-mainz.de> wrote in message news:3A9CFD8F.E269F51F_at_mail.uni-mainz.de...
> Hello,
>
> I wanted to select all rows from a table that start with '12 3456' - two
> numbers followed by space and then again 4 numbers.
> What I tried is:
>
> SELECT vw_lieferung FROM vw_data WHERE vw_lieferung LIKE '__ ____%';
>
> but I get no results (No rows selected).
> How do I have to treat the space character inside the like clause?
>
> Stefan
>
> PS: Please reply to my email address as well.
Received on Wed Feb 28 2001 - 14:34:56 CST

Original text of this message

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