CHARINDEX – CodeRavo

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