在健康体检登记表checklist(cname char(10) ,csex char(1),cage int ,cno char(6) ,ctjrq date,cunit varchar(20),dno char(4))中,要检索 “检索名字为的所有体检人员的姓名”,SQL语句正确的是()
A.
Select cname From Checklist Where cname Like ‘张____’;
B.
Select cname From Checklist Where cname Like ‘张%’;
C.
Select cname From Checklist Where cname Like ‘张_’;
D.
Select cname From Checklist Where cname Not Like ‘张_ _’;