PARSENAME() - a simple way to parse (some) strings in SQL Tue Sep 30, 2003 by Jeff Smith in miscellaneous, t-sql, code-library-sql Handy reminder: The PARSENAME() function can be useful for parsing small strings. It returns parts 1-4 (working right to left) of a string, with each part delimited by periods. For example: Read more →