like-1%.sql

本程序中即有讲义

--Use LIKE with the % wildcard character

USE pubs
GO
SELECT phone
FROM authors
WHERE phone LIKE '415%'
ORDER by au_lname
GO