庫中一個欄位是vchar型，但存的都是數字的形式，如6000,3330,2000等整數的字串，想要洗掉某兩個數值范圍內的所有記錄，如洗掉3000-5000內的所有資料，怎么寫？
string sql_del = "delete from man where cabNum >='" + txtStartNum.Text + "' and cabNum < '" + txtEndNum.Text + "'";
這樣寫好像不對。
uj5u.com熱心網友回復：
delete from man where cabNum Between '3000' And '5000'
uj5u.com熱心網友回復：
字串型別是無法直接比較大小的 你中間加上cast(欄位 as int) 再試試uj5u.com熱心網友回復：
DELETE FROM man where CAST(cabNum AS INT) BETWEEN 3000 AND 5000這兩種應該都可以
DELETE FROM man where CAST(cabNum AS INT)>=3000 AND CAST(cabNum AS INT)<=5000
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/80417.html
標籤：應用實例
上一篇：有沒有大佬幫幫我