Hello,

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?

Thanks

Stefan