Umm Yes

Couldn't you run an SQL to change the data in any street with > 40 down
to 40. Then do the Alter?

Rob

Martijn Tonies wrote:

>> I have a table with a column street varchar(50).
>>
>> I could do an
>> alter table xxx alter street varchar(60)
>> but I could not do an
>> alter table xxx alter street varchar(40)
>>
>> I have to create a temp-column an copy the data over.
>>
>> Is there an easier (and faster) way?
>>
>
> No.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>