AccessÔõô²éѯÕâÒ»ÁУ¿¡¾ÔÚÏߵȡ¿

ÇëÎÊAÁÐΪ²»¹æÔòµÄ×Ö·û´®£¬ÀýÈçÎÒÒª²éѯ15ÔÚÄÇÒ»ÐÐÀAccessÔõô²ÅÄܲéѯµ½ÄØ£¿SQLÊǶàÉÙÄØ£¿Íû¸ßÊÖÖ¸µãÒ»¶þ¡£Ð»Ð»

AÁÐΪ:
1-10
11-13
14-25
26-29

---

ÒýÓÃ

select *
from yourTable
where 15 between left(a,instr(a,'-')-1) and mid(a,instr(a,'-')+1)

ACMAIN_CHMµÄÅóÓÑ
²»ÄÜÔËÐÐà¸
Ìáʾ£ºÎÞЧµÄ¹ý³Ìµ÷ÓÃ

---

¿ÉÒÔµÄ
ÄãµÄÔËÐÐÓïÆø»·¾³ÊÇɶ

---

²¹³äһϻ¹»á³öÀ´
AÁУº
0
1-10
-
11-13
14-25
26-29
µÄÕâÖÖÇé¿ö

---

²»»á°¡£¬ÎÒ×öÁ˸ö²âÊÔûÓÐÄã˵µÄÎÊÌ⣬ÄãÊÇÔõô²âÊԵģ¿

ÏÂÃæÊÇÎÒ×ö²âÊÔÓõÄÀý×Ó£¬²éѯÔÚqeury1 ÖÐ

http://www.access911.net/csdn/FileDescription.asp?mdb=2009-9-18&id=24&mode=3


SQL code:
SELECT *
from Table1;
where 15 between left(a,instr(a,'-')-1) and mid(a,instr(a,'-')+1)

---

ÏȹýÂËûÓõÄÊý¾Ý

SELECT *
from (SELECT *
from (SELECT * from ±í3 WHERE instr(a,"-")>0 and len(a)>1) tt
WHERE 15 between left(a,instr(a,'-')-1) and mid(a,instr(a,'-')+1)) tt

---

ÒýÓÃ

²¹³äһϻ¹»á³öÀ´
AÁУº
0
1-10
-
11-13
14-25
26-29
µÄÕâÖÖÇé¿ö