On Tue, Sep 14, 2004 at 01:21:48PM -1000, Jerome Lyles wrote:
> 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?
That means you havn't closed the opening bracket on the first line.
Every open bracket must be matched by a closing one...
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.