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 - 04:51:57 CST
