27,579
社区成员
发帖
与我相关
我的任务
分享
select max(convert(int,right(gridId,(len(gridId)-charindex('-',gridId)))))
from t_grids where gridId like 'A-%'
SELECT nz(Max(Val(Right(gridId,(Len(gridId)-InStr(gridId,'-'))))),0) AS 表达式1
FROM t_grids
WHERE (((t_grids.gridId) Like 'A-%'));
可以改成这样:
SELECT max(mid(GridId,Instr(GridId,'-')+1)*1)
FROM t_Grids WHERE GridId LIKE 'A-*'