How to Split a String after a Character with SQL Server ?

How to split a simple string stored in a variable after a specific character using SQL Server functions? For example, use the substring function to split a string like file.txt to separate the file name from its extension after … Continue reading How to Split a String after a Character with SQL Server ?