Re: copying to a smaller column

Try using substr.

substr(fieldname,1,100) - this line picks up the first 100 chars of fielname.

On Mon, 21 Jun 1999 17:07:22 +0100, Richard Baines <richardbaines_at_netscape.net> wrote:

>Hi
>
>I have a table containing two varchar2 columns, one of size 500 and one
>of size 100.
>Is there a way of copying the first 100 characters of the 500 column to
>the 100 column.
>I`ve been looking for some form of TRUNC command that works on varchars
>but there doesn`t seem to be anything.
>
>Any help gratefully received
>
>Richard
>
Received on Tue Jun 22 1999 - 11:43:52 CDT