求个sql截取字符然后比较剩余部分大小的语句.
SELECT MAX(SUBSTRING(planGroupid, 14, LEN(planGroupid) - 13)) AS planGroupid FROM PlanGroup WHERE (planGroupid LIKE '%20070524% ')
但是如果JSJSB200705249和JSJSB2007052410 为什么比较出的是9而不是10呢
我要怎么才能取到合适的长度呢?谢谢啦```
[解决办法]
用Convert 转化成int 类型就可以了
9 和10 比较 如果按照字符类型比较 肯定是 9 大
[解决办法]
try
SELECT MAX(CAST(SUBSTRING(planGroupid, 14, LEN(planGroupid) - 13) AS INT)) AS planGroupid FROM PlanGroup WHERE (planGroupid LIKE '%20070524% ')
[解决办法]
SELECT MAX(cast(SUBSTRING(planGroupid, 6, LEN(planGroupid) - 5) as int) AS planGroupid FROM PlanGroup WHERE (planGroupid LIKE '%20070524% ')
