CHARINDEX – CodeRavo

Finding Substrings Within Strings in SQL Server

Identifying Substrings in SQL Server A common task in database management is determining whether a larger … Finding Substrings Within Strings in SQL ServerRead more

CHARINDEX, database, like, pattern matching, SQL Server, string manipulation, string-search, substring, T-SQL

Extracting File Names from Paths in SQL Server

Introduction Working with file paths stored as strings in a database is a common requirement, especially … Extracting File Names from Paths in SQL ServerRead more

CHARINDEX, file paths, SQL Server, sql-manipulation, strings, substring

Efficiently Splitting Comma-Separated Strings into Columns in SQL

When working with databases, you often encounter scenarios where data stored as comma-separated values (CSV) within … Efficiently Splitting Comma-Separated Strings into Columns in SQLRead more

CHARINDEX, cross-apply, parsename, SQL Server, string manipulation, substring, xml-parsing

Advanced SQL Search: Finding Rows Containing All Specified Words

Introduction In database management, a common task is retrieving records where specific words are present within … Advanced SQL Search: Finding Rows Containing All Specified WordsRead more

CHARINDEX, Full-Text Search, LIKE operator, SQL, SQL functions