有一个字段是3*2，我怎么把3跟32截取出来，然后相乘

[幽灵Killer]

有一个字段是3*2，我怎么把3跟2截取出来，然后相乘，怎么截取啊。

[xxfvba]

DECLARE @sql varchar(max); ;with cte(a) as (select '3*2' union all select '12*2') select @sql=(SELECT 'SELECT '+ a+' union all ' from cte FOR XML PATH('')); set @sql=left(@sql,len(@sql)-9) EXEC(@sql);

[qiuchu2003]

DECLARE @sql varchar(max);
SET @sql=(SELECT 'SELECT '+ a+';' from test FOR XML PATH(''));
EXEC(@sql);

[不穿内裤的超人]

with cte(a) as
(select '3*2' union all
 select '12*2')
select cast(
SUBSTRING(a,1,charindex('*',a)-1) as int)
*cast(SUBSTRING(a,CHARINDEX('*',a)+1,len(a)-CHARINDEX('*',a))as int) from cte

拿走给分