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)