CREATE TABLE dbo.Section_suw ( Section varchar(50) NULL ) INSERT INTO dbo.Section_suw (Section.Section) VALUES ('1') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('AB1') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A1') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B2') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A11') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B20') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B21') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('AB10') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B3') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('AB100') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('2') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B1') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('B32') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('11') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A10') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A1B') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A180') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A189') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('180a') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('18a') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('18b') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A18') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('A19') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('19B') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('100') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('Superman') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('Aquaman') INSERT INTO dbo.Section_suw (Section.Section) VALUES ('S')

SELECT Section FROM dbo.Section_suw ORDER BY ISNULL(TRY_CAST(Section as int),2147483647),Section