为什么说ACCESS里,“"ABC" BETWEEN"A"AND"B"的值为TRUE "ABC" BETWEEN"A"A
来源:学生作业帮 编辑:灵鹊做题网作业帮 分类:英语作业 时间:2024/06/28 07:32:26
为什么说ACCESS里,“"ABC" BETWEEN"A"AND"B"的值为TRUE "ABC" BETWEEN"A"AND"ABB"的值为FALSE”
![为什么说ACCESS里,“](/uploads/image/z/5371865-17-5.jpg?t=%E4%B8%BA%E4%BB%80%E4%B9%88%E8%AF%B4ACCESS%E9%87%8C%2C%E2%80%9C%22ABC%22+BETWEEN%22A%22AND%22B%22%E7%9A%84%E5%80%BC%E4%B8%BATRUE+%22ABC%22+BETWEEN%22A%22A)
比方说你查三个单词:HELLO、HOW、OK
"HOW" 就在 BETWEEN "HELLO" AND "OK“ ,因为按词典顺序就是:HELLO,HOW,OK.HOW在中间.
你说的 ABC、A、B,词典顺序是:A、ABC、B,所以ABC在中间
所以:"ABC" BETWEEN"A"AND"B"的值为TRUE
而A、ABB、ABC,词典顺序是:A、ABB、ABC,ABB在中间
所以:"ABC" BETWEEN"A"AND"ABB"的值为FALSE
"HOW" 就在 BETWEEN "HELLO" AND "OK“ ,因为按词典顺序就是:HELLO,HOW,OK.HOW在中间.
你说的 ABC、A、B,词典顺序是:A、ABC、B,所以ABC在中间
所以:"ABC" BETWEEN"A"AND"B"的值为TRUE
而A、ABB、ABC,词典顺序是:A、ABB、ABC,ABB在中间
所以:"ABC" BETWEEN"A"AND"ABB"的值为FALSE