learn

SUBSTRING (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric ...
GitHub

functions-on-string-values-substring.md

fn:substring($sourceString as xs:string?, $startingLoc as xs:decimal?) as xs:string? fn:substring($sourceString as xs:string?, $startingLoc as xs:decimal?, $length as ...
Ars Technica

T-SQL, order by substring?

Is it possible to order by a substring in a returned field? 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 ...
GitHub

SQLQuery11(STRING-SUBSTRING).sql

--NOTE- IT WILL HELP BCZ PEOPLES NAME'S STARTING CHARACTER WILL MATCH BCZ SO MANY USE SHORT NAME INSTEAD OF LONG ...
Ars Technica

You ugly (SQL, Substring, multiple charindex occurrences)

I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...
learn

SUBSTRING - Query language in Cosmos DB (in Azure and Fabric)

The SUBSTRING function returns part of a string expression starting at the specified position and of the specified length. An Azure Cosmos DB system function that returns a portion of a string using a ...