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

SQL SUBSTRING behavior across various DBs, including Tsurugi

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 ...
learn

Functions on String Values - substring

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 ...
GitHub

functions-on-string-values-substring.md

Note the following from the previous query: The string () function returns the string value of the<Summary> element. This function is used, because the <Summary> element contains both the text and ...
GitHub

translate-sql-string.R

#' implementing a new backend. They are typically used within [sql_translator()] #' to define how R string functions should be translated to SQL. #' * `sql_substr()` creates a SQL substring function ...
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 & ...