On Fri, Oct 24, 2003 at 04:27:16PM -0700, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend