Re: copying to a smaller column

select substr(column, start_pos, length) .....

eg

select substr(emp_name,1,500)......

M

Richard Baines wrote in message <376E633A.5FF1C451_at_netscape.net>...
>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 Mon Jun 21 1999 - 11:32:48 CDT