7-16.sql

SQL2000跟课件学习的源代码 分享共同学习

USE Educational
GO
SELECT  *  FROM  Student WHERE StudentName LIKE '李%'; 
SELECT  *  FROM  Student WHERE StudentName LIKE '_[林, 琳]%'; 
SELECT  *  FROM  Student WHERE StudentName LIKE '%[林, 琳]'; 
SELECT  *  FROM  Student WHERE StudentName LIKE '%[林, 琳]%';