如何订购VARCHAR [英] HOW TO ORDER THE VARCHAR

问题描述

如何将varchar fiels命名为前2个字符固定的数字



例如我的值为



mr1

mr100

mr2

mr110

mr101

mr1000



和订单价值应该像



mr1

mr2

mr100

mr101

mr110

mr1000

How to order the varchar fiels as like number where first 2 char are fixed

eg I Have values like

mr1
mr100
mr2
mr110
mr101
mr1000

and the order valus should be like

mr1
mr2
mr100
mr101
mr110
mr1000

推荐答案

正如Carlo所说，你需要在 ORDER 子句中提取数字部分。

As Carlo said, you need to extract numeric part in ORDER clause.

SELECT ColumnName
FROM TableName
ORDER BY CONVERT(INT, RIGHT(ColumnName, LEN(ColumnName)-2))

只需提取字段和基数的数字部分即可您的订单条款。

Just extract the numeric part of the field and base your order clause on that.

SELECT [COLUMN Name] FROM [Table Name] ORDER BY CONVERT（INT，RIGHT（COLUMN Name） ，LEN（COLUMN名字）-3））



试试这个......它会起作用..

SELECT [COLUMN Name] FROM [Table Name] ORDER BY CONVERT(INT,RIGHT(COLUMN Name,LEN(COLUMN Name)-3))

Try this..it will work..

这篇关于如何订购VARCHAR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！