你可能感兴趣的试题
Left(“姓名”,1)=“刘” Right(“姓名”,1)=“刘” Left([姓名],1)=“刘” Right([姓名],1)=“刘”
Len([姓名])<=2 Len([姓名])<=4 Like "" ""
Not“张三,李四” In(“张三,李四”) Left([姓名]=“张三,李四” Len([姓名])=“张三”,“李四”
NOT"张三*" NOT"张三" LIKE"张三" "张三/
Not"李," Like"李" LeO([姓名],1)= "李" "李"
Like "教授" Left([职称],2)="教授" "教授" 以上都对
Not"仲*" Like"仲" Left([姓名],1)="仲" "仲/
Not“仲*” Like“仲” Left([姓名],1)“仲” “仲”
In("张三","李四") Like "张三" And Like "李四" Like("张三","李四") "张三" And "李四"
Like“教授” Left([职称],2)=“教授” “教授” 以上都对
Not“仲*” Like“仲” Left([姓名],1) =“仲” “仲”
III("张三","李四") Like"张三"AndLike"李四" Like("张三","李四") ”张三"And"李四"
Not"仲*" Like"仲" Left([姓名],1)="仲" "仲"
NOT IN("张三","李四") "张三"OR"李四" Like("张三","李四") "张三"And"李四/
Like "计算机" 计算机 Left([课程名称],3)="计算机" 以上都对