RE: Convertion from varchar to long

Hi Ruediger, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > I need to convert a table field from varchar to long varchar. > > > Is there a way to bring data from a varchar field into a long varchar > field in another table using sql, > or is there another possibility of converting the

Convertion from varchar to long

Hi, I need to convert a table field from varchar to long varchar. I tried alter table myTable add myNewField long varchar but it failed with: -7032: SQL statement not allowed for column of data type LONG I successfully created a new table as a copy of myTable but with a LONG VARCHAR field i