Use SQL "LIKE" keyword together with the "%" wildcard. For example: SELECT * FROM authors WHERE fname LIKE 'J%' (will give you John and Jason) SELECT * FROM authors WHERE telephone LIKE '54%' (will give you all lucky authors living in Argentina -- such as myself!)
Dig deeper on .NET Framework database programming best practices
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ...continue reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers.continue reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.