检查字段是否为数字，然后在一条语句中仅对那些字段执行比较？

检查字段是否为数字，然后在一条语句中仅对那些字段执行比较？

这对你有用吗？

select * from purchaseorderswhere (case when IsNumeric(purchase_order_number) = 1       then cast(purchase_order_number as int)       else 0 end) >= 7