clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601427 fiddles created (48008 in the last week).

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')
28 rows affected
 hidden batch(es)


SELECT Section FROM dbo.Section_suw ORDER BY ISNULL(TRY_CAST(Section as int),2147483647),Section
Section
1
2
11
100
180a
18a
18b
19B
A1
A10
A11
A18
A180
A189
A19
A1B
AB1
AB10
AB100
Aquaman
B1
B2
B20
B21
B3
B32
S
Superman
 hidden batch(es)