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

Why Trust Us

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

See also  lenso.ai - an AI reverse image search platform
Disclosure
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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More