On Mon, 7 Jan 2002, Jon Lapham wrote:
> I have a column defined as "char(3)[]" which I would like to copy into a
> different column defined as "varchar(255)".
>
> I've tried to cast the char(3)[] field using "CAST( ... as varchar)" but
> I get an error message, "Cannot cast type '_bpchar' to 'varchar'".
>
> Any suggestions?
What are you trying to get out? You've got a char(3) array, what do you
want the varchar to have in the end?