Re: HELP: Assigning a high-length VARCHAR2 to a low-length one
From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: 2000/01/18
Message-ID: <948192894.73480_at_red.parallax.co.uk>#1/1
Date: 2000/01/18
Message-ID: <948192894.73480_at_red.parallax.co.uk>#1/1
The function you need is substr.
Peder <peder.pedersen_at_fillmbyen.com> wrote in message
news:861dsa$o2p$1_at_news1.tele.dk...
> Hello,
>
> Could anyone please help me with a small problem:
>
> I need to assign v1 to v2, where v1 is VARCHAR2 with a greater length than
> v2. Is this possible? An error is raised when I attempt.
>
> If this is not possible, is there a way to extract the n leading
characters
> of a VARCHAR2 string?
>
> Thanks in advance,
>
> Peder
>
>
Received on Tue Jan 18 2000 - 00:00:00 CET