**
@TOC在这里插入代码片
select top 1000 SUBSTRING( FBILLNO , 1 , CHARINDEX(’-’,FBILLNO)-1 ) from T_SAL_OUTSTOCK