List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 9 2000 7:56pm
Subject:Re: Selecting only X number of chars from field..
View as plain text  
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
Thread
Selecting only X number of chars from field..Matt Glaves9 Sep
  • Re: Selecting only X number of chars from field..Paul DuBois9 Sep