Names That Start With A : Select * from students where name like 'm%' we can use any one of the following 3 sql server functions, to achieve exactly the same thing.