devxlogo

Selecting Pattern Matching Data by Using the Like operator in a T-SQL Query

Selecting Pattern Matching Data by Using the Like operator in a T-SQL Query

Say you want to retrieve all of the authors whose last names started with an L, M, or S. Here’s the query:

 select au_lname, au_fname from authors where au_lname like '[LMS]%'au_lname                                 au_fname---------------------------------------- --------------------Locksley                                 CharleneMacFeather                               StearnsMcBadden                                 HeatherSmith                                    MeanderStraight                                 DeanStringer

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist