Patrick,
James Moe <jimoe@sohnen-moe.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@newn.cam.ac.uk>:
> On Fri, Oct 24, 2003 at 04:27:16PM -0700, Lynn.Tilby@asu.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
>
