Conversion from CHAR to VARCHAR2

[YipYeppp]

Hi!!

I have this simple problem, but don't know how to resolve it: source table have char type, and target table have a varchar2 type. I don't know how to do the conversion from one type to the other, and the script give me an error because the types are different. I cant change them..

Help !!!

 

[BJCooperIT]

Could you post the script (or part of it) and the error?

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML to help readability. Thanks![sup]