Re: Selecting only X number of chars from field..

[Paul DuBois]

At 3:57 PM -0500 09-09-2000, Matt Glaves wrote:
>Is it possible to select the first X number of characters from a field?  I
>would like to select the first 50 chars from a text or varchar field.
>
>I looked all over the docs but could only find a way to limit by rows or
>numerical functions.

Sounds like you want LEFT(col_name,50).

-- 
Paul DuBois, paul@stripped