数量转平方数

SUM(CASE WHEN CHARINDEX('*',LTRIM(RTRIM([cpgg])))= 0 THEN 0

ELSE CAST(LEFT(LTRIM(RTRIM([cpgg])),CHARINDEX('*',LTRIM(RTRIM([cpgg])))- 1)AS FLOAT)*

CAST(SUBSTRING(LTRIM(RTRIM([cpgg])),CHARINDEX('*',LTRIM(RTRIM([cpgg])))+ 1, 10)AS FLOAT)*

ISNULL([ks],0)*ISNULL(sl, 0.0)/ 1000000.0  END) fs