SELECT ISNUMERIC('dfadf') --查询出来就是0,代表不是数字
SELECT ISNUMERIC('123') --查询出来是123
所以字段值是动态的,可以通过这种方式判断,如果要作为查询条件区间查询那么语句如下:
select * from FX_BS_T_Product where isnull(Disabled,0)=0 and sCode like '%sp-1%' and fSalePrice>=0.000000 and fSalePrice<=10.000000 and ProductColumn1 like '%1%'
and (case when ISNUMERIC(ProductColumn2)=1 THEN ProductColumn2 ELSE 0 END)>=2 AND (case when ISNUMERIC(ProductColumn2)=1 THEN ProductColumn2 ELSE 0 END)<=3