Re: no records returned

Patrick,

James Moe <jimoe(at)sohnen-moe(dot)com>
also suggested this...

It WORKS!!!

Could you explain to a newbie WHY the like and % at
the end of the literal works when the normal select does
not?

Thanks,
Lynn

Quoting Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>:

> On Fri, Oct 24, 2003 at 04:27:16PM -0700, Lynn(dot)Tilby(at)asu(dot)edu wrote:
> ...
> > ZRAN |2003-10-03| 20031003| 731491| 20.25| 21.
> > (609398 rows)
>
> > pma=> select * from stck_dta_tbl_oprtnl where stck_sym = 'ZRAN';
>
> How about
>
> pma=> select * from stck_dta_tbl_oprtnl where stck_sym like 'ZRAN%';
>
> ? (What is the definition of your table?)
>
> Cheers,
>
> Patrick
>