ALTER statement for a table w/ a space in the name???

[edwilson]

Does anybody know how to format an ALTER statement for a table that has a
space in the name? Before you flame me, no I did not design the table. I
need to change the length of a single field in the table, but the ADO keeps
barfing on the ALTER statement. Here are the various ways that I've tried it:

ALTER TABLE [Split Definition] ALTER COLUMN Number TEXT(4);

ALTER TABLE Split Definition ALTER COLUMN Number TEXT(4);

ALTER TABLE "Split Definition" ALTER COLUMN Number TEXT(4);

Thanks
Eric

 

[edwilson]

Never mind. I figured it out. Duh.

ALTER TABLE [Split Definition] ALTER COLUMN [Number] TEXT(4);