If length is omitted, all characters from the start position to the end of the expression is returned. You can use substring with an optional length argument. However, if you use NULL for length, ...
SUBSTRING is a standard SQL function used to extract a portion of a string. It is defined in ISO/IEC 9075 (commonly known as ISO SQL) and is supported by many database products. SUBSTR is an SQL ...
E. Use SUBSTRING with optional length argument Applies to: Azure SQL Database, Azure SQL Managed Instance, Azure Synapse Analytics, Analytics Platform System (PDW), SQL analytics endpoint, and ...