copying to a smaller column

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:07:22 CDT