这对你有用吗?
select * from purchaseorderswhere (case when IsNumeric(purchase_order_number) = 1 then cast(purchase_order_number as int) else 0 end) >= 7

这对你有用吗?
select * from purchaseorderswhere (case when IsNumeric(purchase_order_number) = 1 then cast(purchase_order_number as int) else 0 end) >= 7