Hi. I have to change the Column Type of two coumn in the database. In the old Day's with MySQL it was doing with the following statement:
ALTER TABLE Invoice CHANGE SQLKnr SQLKnr VARCHAR(8); This change the column-type from integer to varchar(8) I was trying this with several variations but no luck. It's luck like that ALTER is not supportet. My question is how can I change the type without retyping al the information, that is not an easy job becouse of the amount of the enree's. I hope there is a better way. Regards Erwin Jabor --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 7/2/2004
