>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? ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])