Hi,

> I want to write SQL script for database modification.
> Can someone tell me is it possible to change existing varchar(200) field
> into varchar(150) when the table contains data longer than 150 symbols.
> Currently I get truncation error when trying to update data from longer
> field to shorter.

The only way to do this is to create a new column,
move the data and drop the old column.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com