ALTER TABLE dbo.SALES ADD testX tinyint NULL ALTER TABLE dbo.SALES ADD testY tinyint NULL SELECT dbo.SALES.* FROM dbo.SALES WHERE (JAN = '49021201') ALTER TABLE dbo.SALES DROP column testY ALTER TABLE dbo.SALES DROP column testX