Split a string after a character with SQL Server

How to split a string after a particular character with the SQL substring function? For example, use the substring function to split a string like file.txt to separate the file name from its extension after the dot character. Indeed, it is obvious that splitting a string just before the point character must be done dynamically, i.e., whatever the position of the character is. How … Continue reading Split a string after a character with SQL Server