Re: selecting left x characters from a field?

In article <8plmte$scp$1_at_nnrp1.deja.com>,   Medfly <medfly_at_iname.com> wrote:
> Is there an equivalant LEFT or RIGHT function from VB that works in
> Oracle?
>
> Key
> ---
> 12345
>
> Is there a way to select the first 3 characters?
>
> SELECT LTRIM(Key,3) .... doesn't do the trick.
>
> thanks - medfly
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Hi
Try SUBSTR Function

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 12:11:22 CDT