LinkedIn

Learn SQL Server SUBSTRING and CHARINDEX Functions Through Practical Example

SUBSTRING and CHARINDEX functions are two of the most commonly used string functions in SQL. They allow you to extract and search for substrings within strings. SUBSTRING: The SUBSTRING function is ...
GitHub

substring-transact-sql.md

[!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb.md)] Returns ...
LinkedIn

SQL Server 2025 SUBSTRING Update Allows Optional Length Parameters

Dogpaddling as hard as I can to keep up with the demand I put on myself (yeah, it never helps when it is actually your fault does it.) But this week I took at look at the change to SUBSTRING in SQL ...
makeuseof

SQL String Functions: 10 of the Most Useful

Sandra is a Tech enthusiast with a Journalism and Full-stack web development background. She specializes in web development and Cloud technology. For leisure, Sandra enjoys a good thriller, hugging ...
Ars Technica

T-SQL, order by substring?

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...