On Thu, 29 Dec 2011 10:39:41 -0500
Frank Bax <fbax@sympatico.ca> wrote:
> > Oops, I'm read too fast; but it dont change my PB:
> > SELECT * FROM table WHERE col> 'Y%' still returns y%& Y%
> >
>
> NO. It does not.
>
> create table barbier (col varchar);
> insert into barbier values ('y%');
> insert into barbier values ('z%');
> insert into barbier values ('Y%');
> select * from barbier where col>'Y%';
> col
> -----
> y%
> z%
> (2 rows)
Do you mean that>'Y%' is taken as a literal and don't
develop as Y* (contrary to LIKE 'Y%')?
Meaning 'Y%' was for me: 'Yahoo', 'Ybsd', 'Ycommerce', 'Ymail', etc
--
Damn, I need a Coke!
-- Dr. William DeVries
[after implanting the first artificial human heart]