单项选择题

若要求查找姓名中第一个字为‘刘’的学生号和姓名。下面列出的SQL语句中,哪个是正确的

A.SELECT S#,SNAME FROM S WHERE SNAME='刘%'
B.SELECT S#,SNAME FROM S WHERE SNAME='刘_'
C.SELECT S#,SNAME FROM S WHERE SNAME LIKE='刘%'
D.SELECT S#,SNAME FROM S WHERE SNAME='刘_'