Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Assigning a high-length VARCHAR2 to a low-length one
Hi,
did you tried: substr(v1, 1, n), where n is the length of v2?
Regards
Dirk Mika
Peder schrieb:
>
> 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:56:05 CST