sql中将数据类型 nvarchar 转换为 numeric 时出错怎么办

[zhuailcz]

select *
from organization o,customer c
where c.customer_square=o.structid

customer_square是nvarchar类型，structid是numeric类型。求大神啊！！在线等！

[shoppo0505]

select * from organization o,customer c where c.customer_square= convert(nvarchar(10),o.structid)

[唐诗三百首]

select * 
 from organization o,customer c 
 where c.customer_square=cast(o.structid as nvarchar)

[叶子]

select * 
from organization o,(select * from customer where isnumeric(customer_square)=1) c 
where c.customer_square=o.structid

[蝈蝈(GuoGuo)]

表设计有问题，通过这些方式可以查询到，但是会影响到系统的性能（进行表扫描）