By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @T table
(
numberstring varchar(11) COLLATE Latin1_General_100_CI_AS NOT NULL
);
INSERT @T (numberstring) VALUES
('-4'),
('32'),
('0'),
('4'),
('16'),
('8'),
('-8'),
('1024');
SELECT * FROM @T AS T ORDER BY T.numberstring;
| numberstring |
|---|
| 0 |
| 1024 |
| 16 |
| 32 |
| 4 |
| -4 |
| 8 |
| -8 |
DECLARE @T table
(
numberstring varchar(11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
);
INSERT @T (numberstring) VALUES
('-4'),
('32'),
('0'),
('4'),
('16'),
('8'),
('-8'),
('1024');
SELECT * FROM @T AS T ORDER BY T.numberstring
| numberstring |
|---|
| -4 |
| -8 |
| 0 |
| 1024 |
| 16 |
| 32 |
| 4 |
| 8 |