问个关于SQL语句的问题
"SELECT * FROM [Record] WHERE [操作员]='@V1' AND [编号] BEWTEEN '@V2' AND '@V3'"
为什么总提示这个SQL语句有问题……我就是想查询俩条件同时成立的条目……
一个条件是确定的值，也就是@V1
还有一个条件是一个范围，也就是后边的betweenXXX……
谁告诉我该咋写……
我源代码是这样写的：

VB.NET code

 Public Function SearchAndReturnTimeAndUserBack(ByVal User As String, ByVal BeginTime As Long, ByVal EndTime As Long, ByVal DT As DataTable)        Dim DB_Connection As New OleDb.OleDbConnection        DB_Connection.ConnectionString = DB_ConStr()        DB_Connection.Open()        Dim DB_Command As New OleDb.OleDbCommand("SELECT * FROM [Record] WHERE [操作员]='@V1' AND [编号] BEWTEEN '@V2' AND '@V3'", DB_Connection)        DB_Command.Parameters.AddWithValue("@V1", User)        DB_Command.Parameters.AddWithValue("@V2", BeginTime)        DB_Command.Parameters.AddWithValue("@V3", EndTime)        Dim RS As New OleDb.OleDbDataAdapter        RS.SelectCommand = DB_Command        RS.Fill(DT)        DB_Connection.Close()        Return DT    End Function