表示为字符串的数字的SQL/JQL“介于”

在进行比较之前,可以尝试将value列转换为数字数据类型,如下所示:

SELECT *
FROM YOURTABLE
WHERE CAST(VALUE AS INT) BETWEEN 100 AND 110

这将确保对数值而不是文本进行比较。

如果要传递的参数 VARCHAR 数据类型作为参数,您还需要像这样显式地转换它们:

SELECT *
FROM YOURTABLE
WHERE CAST(VALUE AS INT) BETWEEN (CAST @Lower AS INT) AND (CAST @Upper AS INT)