CREATE TABLE #T1
(
col varchar(10) not null
)
insert into #T1
Select '1' union
Select '4' union
Select 'a' union
Select 'c' union
Select '7' union
Select '2' union
Select 't' union
Select 'b'
Select * From #T1 order by col
col
----------
1
2
4
7
a
b
c
t
(8 行受影响)
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tba')
BEGIN
DROP TABLE tba
END
GO
CREATE TABLE tba
(
memo VARCHAR(100)
)
GO
INSERT INTO tba
SELECT '7' UNION
SELECT '21' UNION
SELECT 'a' UNION
SELECT 'e' UNION
SELECT '8' UNION
SELECT '1' UNION
SELECT 'c'
GO
SELECT memo
FROM tba
ORDER BY CASE WHEN ISNUMERIC(Memo) > 0 THEN CAST(memo AS INT)
ELSE 2147483647 END
memo
1
7
8
21
a
c
e
