Order by 按指定关健字排序1

[liao71]

有客户提出，不按A，B，C,W 这样排序，按指定的关健字，如 B,W,C,A这样排，想请教一下如何实现

[bancxc]

order by B,W,C,A

[gw6328]

order by case col when 'B' then 1 when 'W' then 2 when 'C' then 3 when 'A' then 4 else 5 end asc

[-晴天]

[Quote=引用 2 楼 jinfengyiye 的回复:]
order by case col when 'B' then 1 when 'W' then 2 when 'C' then 3 when 'A' then 4 else 5 end asc
[/Quote]
+1

[qgqch2008]

[Quote=引用 2 楼 jinfengyiye 的回复:]

order by case col when 'B' then 1 when 'W' then 2 when 'C' then 3 when 'A' then 4 else 5 end asc
[/Quote]只能是这样了

[sleet96]

order by CHARINDEX(SUBSTRING(value,1,1),'BWCA')

[--小F--]

order by charindex(col,'BWCA')

[mabailin]

[Quote=引用 6 楼 fredrickhu 的回复:]

SQL code
order by charindex(col,'BWCA')
[/Quote]
牛

[回南山种豆]

[Quote=引用 5 楼 sleet96 的回复:]

order by CHARINDEX(SUBSTRING(value,1,1),'BWCA')
[/Quote]
ding

[chenyanyan101]

这也想的出，强

[sunqiso]

这也想的出，强