> I am using Delphi 5 with Firebird 1.5.1, but I have not done a lot of SQL
> with Firebird recently.
>
> I have a field as follows:
> ISBN VARCHAR(10)
>
> I need to expand this field to 13 digits instead of 10. There are already
> existing records.
>
> What is the SQL to change this?

ALTER TABLE mytable
ALTER myfield TYPE VarChar(13)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com