可以。
如:
CREATE TABLE #T([id] int IDENTITY(1,1),d nvarchar(20))
INSERT INTO #T
SELECT 'Asafdsa' UNION ALL
SELECT 'eeee' UNION ALL
SELECT '232' UNION ALL
SELECT 'zsfff' UNION ALL
SELECT 'TEMP'
--现在固定把含有d='TEMP'这一行数据放在最前,其他按d升序排序
--修改前
SELECT * FROM #T ORDER BY d
--修改后
SELECT * FROM #T ORDER BY CASE d WHEN 'TEMP' THEN '00000' ELSE d END