Subject Re: [IBO] IBOGrid and varchar problem
Author Dmitry Beloshistov
Hello, yuraukar!
You wrote to <> on Fri, 21 Jan 2005 12:03:32 -0000:

y> (As an alternative: does anyone know a way to convert a
y> varchar(10000)
y> column into a char(200) column via sql? simply altering the data type
y> via ALTER TABLE doesn't do the job).

For Firebird 1.5.x:

1) Create new field as varchar(200);
2) UPDATE TableName
SET NewVC200FieldName=SUBSTRING(OldVC10000FieldName FROM 1 FOR 200);

WBR,Dmitry Beloshistov AKA [-=BDS=-]