Daniel Janik continues his SQL Server versus Oracle syntax comparison series:
Parsing strings is a feature that is often needed in the database world and SUBSTRING/SUBSTR are designed to do just that. I find it interesting how these two platforms approached the functions differently and that’s definitely shows how you can do many things to get to the same answer.
It’s a short post, but Daniel does show one big difference between the Oracle and SQL Server substring functions.