Re: SQL: whitespaces in like-clauses?

From: Andreas Necker <Andreas.Necker_at_isb-ka.de>
Date: Thu, 01 Mar 2001 13:24:15 +0100
Message-ID: <3A9E3F6F.FBEAA4D0@isb-ka.de>

hi,

Stefan R hle wrote:
>
 

> Hello,
>
 

> I wanted to select all rows from a table that start with '12 3456' - tw
 o
> 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?
>

which db-version?
is vw lieferung a table or a view? (->where-clause)

select * from test;
TEXT

---

12 3456abc
2 3456def
45 6789ghi

select * from test where text like ' %'; TEXT

---

12 3456abc
45 6789ghi

everything is ok ?!

-- 

Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ka.de
Germany             http://www.isb-ka.de

Received on Thu Mar 01 2001 - 06:24:15 CST