Sql代码
1.SELECT @Str = SubString(@Str,DataLength(@Str)-4,5)

2.SELECT @Str=RIGHT(@Str,5)

3.Declare @str varchar(10)
set @str='abcdefgddsss'
SELECT @Str=RIGHT(@Str,5)
print @str

4.sql中length(字段名)取长度。

2010.2.22

砼强度等级分组排序

SELECT IValue
FROM Sys_MisParameter
WHERE (IType = '砼强度等级')
ORDER BY SUBSTRING(IValue, 4, 97)

作者“AlecRichard's Blog”