Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: whitespaces in like-clauses?
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