Re: whitespaces in like-clauses?

better :

SELECT vw_lieferung FROM vw_data
WHERE (substr(vw_lieferung,1,2) between '00' and '99') and (substr(vw_lieferung,4,4) between '0000' and '9999')

didn't test it though but the idea is more ipmortant than the right syntax.

greets

"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 Thu Mar 01 2001 - 04:47:55 CST