On Tuesday 14 September 2004 01:31 pm, Duane Lee - EGOVX wrote:
> Do this:
>
>
> SELECT SUBSTR(prod_name,1,45) from Products;
>
>
> Duane
I did:
sql_tutorial=> SELECT SUBSTR(prod_name,1,45) from Products;
substr
---------------------
8 inch teddy bear
12 inch teddy bear
18 inch teddy bear
Fish bean bag toy
Bird bean bag toy
Rabbit bean bag toy
Raggedy Ann
King doll
Queen doll
(9 rows)
Thanks,
Jerome