SELECT fID,Substring(fName,1,LEN(fName)-3),fName FROM [Test_Recharge].[dbo].[AcProduct] 用到的函数Substring #ms-sql