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

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 ...
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 ...
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 & ...
note

[Practice! SQL] String Manipulation Part 1 (SUBSTR / CONCAT)

Extracting categories from product codes, getting domains from email addresses, concatenating multiple values for labels—string processing is a daily occurrence. First, it is recommended to organize ...
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 ...