That is true.. your script evaluates in the same way as mine does. As noted, there exists many approaches that includes yours.

However, the SUBSTRING function along with CHARINDEX seems costlier than the PARSENAME...

Neverthless, thanks for adding this code piece 🙂