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)