>This is not for -hackers.
How so?
>And the answer is "no, you can't". Recreate the table with correct types
>and insert the old values into it.
You're kidding me, right? *prepares to gargle* MS Sql server can. Surely
we can implement this feature or aren't we aiming to go head to head with
commercial rdbms'?
>>On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
>> I posted this in my last message, but have not heard anything yet so I'm
>> wondering if it was overlooked. I need to know how to change a column
from
>> being say a varchar(9) to an integer. Does anyone know how to change the
>> data type?