Is it possible to modify Datatipe using ALTER TABLE?:confused:Yes, it is.
Example:
ALTER TABLE customers
ALTER COLUMN street_address
varchar(35)
If this doesn't help you, search Books Online for a more comprehensive help regarding ALTER TABLE.|||Thanks a lot, it works perfect!!