S
strict9
Hello,
I am trying to use the following line to change a zip code field from
10 to 5 digits:
db.Execute "ALTER TABLE [Master] ALTER COLUMN [MailZip] NUMBER(5)"
However, it gives me the error "Sytax error in ALTER TABLE statement."
If I remove the (5) it works just fine. Any ideas?
I am trying to use the following line to change a zip code field from
10 to 5 digits:
db.Execute "ALTER TABLE [Master] ALTER COLUMN [MailZip] NUMBER(5)"
However, it gives me the error "Sytax error in ALTER TABLE statement."
If I remove the (5) it works just fine. Any ideas?