语法没有错误，sql就是找不到，

ID one two 
1 Manchester City Manchester City
2 Manchester United Manchester United
3 Arsenal Arsenal FC
4 Chelsea Chelsea FC
5 Newcastle United Newcastle United
6 Swansea City Swansea City
7 Tottenham Hotspur Tottenham Hotspur
8 Aston Villa Aston Villa
9 Liverpool Liverpool FC
10 Norwich City Norwich City
11 Stoke City Stoke City
12 Everton Everton FC
13 Wolverhampton Wolverhampton Wanderers
14 West Bromwich(WBA) West Bromwich Albion
15 Fulham Fulham FC
16 Sunderland Sunderland FC
17 Queens Park Rangers Queens Park Rangers
18 Wigan Athletic Wigan Athletic
19 Blackburn Rovers Blackburn Rovers
20 Bolton Wanderers Bolton Wanderers
21 Southampton Southampton FC
22 West Ham United West Ham United
23 Birmingham City Birmingham City
24 Leicester City Leicester City

以上是数据表格式，我使用了 
Adodc2.RecordSource = "select * from england where one='norwich city '" 来查询，就是返回的空的，什么也没有

我就测试性用了

Adodc2.RecordSource = "select * from england where ID>5" 来查询，就可以返回数据。不知道到底是为什么呢。

请教了。

哎呀，还是英超积分排名。是不是空格问题？

Adodc2.RecordSource = "select * from england where one like 'norwich city%'"

估计是大小写敏感吧。
SQL code

select * from england where one='Norwich City'