Re: Spacing in output

On Tuesday 14 September 2004 11:15 am, you wrote:
> What is the field size of prod_name?  You could use SUBSTR(prod_name,1,xx)
> where xx is the max number of characters you want to see.
>
> Duane
fieldsize: 255.  I tried to use SUBSTR:

sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products;
sql_tutorial(>
sql_tutorial(>
sql_tutorial(> SELECT prod_name FROM Products;
sql_tutorial(> SUBSTR(prod_name,1,45;

but I have the syntax wrong.  What does '(>' instead of '=>' mean?
Thanks,
Jerome