The company has Windows 98 computers and an inventory database using MS Jet 3.5. Using SQL, I need to make a text field wider, from 16 to 20. I am a SQL novice and when I tried ALTER TABLE [Product] ALTER COLUMN [Product Code] TEXT(20) also ALTER TABLE [Product] ALTER COLUMN [Product Code]SET TEXT(20) also ALTER TABLE [Product] ALTER [Product Code] TEXT(20) these did not work. How can I make this text field wider?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL to widen a Text field?
- Thread starter Zoon
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question