ALTER TABLE bands ALTER COLUMN state TYPE VARCHAR(100);