The Curious Consultant
Menu Close
  • Home
  • Here’s everything!
    • C#
    • SQL
    • General
    • Code
      • C# Code
      • JavaScript/TypeScript Code
      • SQL Code
    • Tips and Techniques
      • C# Tips and Techniques
      • Nintex Form Tips and Techniques
  • About Dave
  • My Blogs
  • Contact Me Anytime!

LIKE

11

SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX

Posted on October 7, 2015 by David Lozinski
SQL Code

LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX All too often developers need to query a database table for records which begin and/or end with a certain textual pattern. For instance, find all employees where their first name begins with “DAV”.… Continue Reading →

SQL CHARINDEX, LEFT, LIKE, RIGHT, sql, substring

Subscribe to be notified of new posts:

Loading

Most Popular Last 30 Days

  • SQL: Fastest way to insert new records where one… (986)
  • C# .Net: Fastest Way to Read Text Files (943)
  • SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX (440)
  • C# .Net: Fastest Way to check if a string occurs… (371)
  • SQL: Fastest way to compare multiple column values (362)

Categories

Latest Comments:

  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • Mike H on C#: Dictionary Vs ConcurrentDictionary
  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • danzar on Length Vs Count Vs Initialized Variable in C#
  • 5Arete23 on Fastest Collection for String Lookups in C# .Net

Recent Posts

  • Does How You Access Class Properties Make A Difference?
  • Things I do to increase Windows drive performance
  • Massive SQL Date Time Cheat Sheet
  • Division Vs Multiplication Equivalent
  • Does caching calculated loop indexes make a difference?

Everything Else!

Here's Everything if you're trying to find a post, missed some, or just want to see, well, everything. :-)
© 2023 The Curious Consultant. All rights reserved.
Hiero by aThemes